SQL > Data Definition Language (DDL) > Drop Database Statement

Sometimes we may decide that we need to delete of an entire database in the RDBMS. In fact, if we cannot do so, we would be faced with a maintenance nightmare. Fortunately, SQL allows us to do it, as we can use the DROP DATABASE command. The syntax for DROP DATABASE is,

DROP DATABASE "database_name";

So, if we wanted to drop the HOLIDAYS database that we created in the CREATE DATABASE section, we simply type

DROP DATABASE HOLIDAYS;

Please note that any table that is still in the database will also disappear once the database is dropped.

Next: SQL Constraint




Copyright © 2014   1keydata.com   All Rights Reserved.     Privacy Policy