Deletion of a database or table

You can delete a database or table using the drop command.

Syntax

The following syntax shows how to use the drop command

drop table database_name.table_name ;
drop database database_name ;

Example

The following example deletes the entire staff.managers table. 

|phoenix:1.> drop table staff.managers;
|phoenix:2.> go

The following example deletes the entire staff database. 

|phoenix:1.> drop database staff;
|phoenix:2.> go