1.1 sql create and drop database statement

The CREATE DATABASE statement is used to create a new SQL database.

1. SQL CREATE DATABASE Statement AND SQL DROP DATABASE Statement DATABASE SYSTEM 2 ANGELO T. RETITA IT-INSTRUCTOR

2. Objectives 1. Will be able to understand the SQL CREATE DATABASE Statement. 2. Will be able to determine the syntax of SQL CREATE DATABASE Statement. 3. Will be able to understand the SQL DROP DATABASE Statement. 4. Will be able to determined the syntax of SQL DROP DATABASE Statement.

3. SQL CREATE DATABASE Statement The CREATE DATABASE statement is used to create a new SQL database.

4. Syntax CREATE DATABASE databasename ;

5. CREATE DATABASE Example CREATE DATABASE testDB ; Databases Before Databases After

6. SQL DROP DATABASE Statement The DROP DATABASE statement is used to drop an existing SQL database.

7. Syntax DROP DATABASE databasename ; Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!

8. DROP DATABASE Example The following SQL statement drops the existing database " testDB ": DROP DATABASE testDB ; Databases Before Databases After