Apache Derby – Drop Table The DROP TABLE statement is used to remove an existing table including all its triggers, constraints, permissions. Syntax Following is the Syntax of the DROP TABLE statement. ij> DROP TABLE table_name; Example Suppose you have a table named Student in the database. The following SQL statement deletes a table named […]
Author Archives: user
Apache Derby – Deployment Modes You can deploy apache derby in two modes, namely embedded mode and server mode. Embedded mode You can run derby in embedded mode using Java application (using embedded driver). If you deploy Derby in embedded mode, the database engine will run in the same JVM as the Java application. It […]
Amazon RDS – Event Notifications Throughout the life cycle of amazon RDS DB instances, many DB events occur which are important to be known beforehand. For example – A backup of the DB instance has started, or an error has occurred while restarting MySQL or MariaDB. Notification Categories Based on the nature of the event, […]