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 table called customer 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 INSERT INTO
|| Copyright © 2013 1keydata.com All Rights Reserved.