|
SQL BASIC
|
|
|
|
DATA QUERY LANGUAGE
|
|
|
|
BASIC FUNCTION
|
|
|
|
AGGREGATE FUNCTION
|
|
|
|
DATA MANIPULATION LANGUAGE
|
|
|
|
DATA DEFINITION LANGUAGE
|
|
|
|
DATA CONTROL LANGUAGE
|
|
|
|
OTHERS
|
|
|
|
|
|
|
|
DROP
|
Deleting table that you no longer need is fairly easy. Just use the
following DROP command to delete the Employee table.
|
|
DROP
TABLE Employee
The DROP TABLE command will also deletes all indexes associated with
that table. However, SQL:2003 does not provide a command to only delete the
indexes without deleting the table. Most database vendors have extended their
SQL dialects to include this command.
|
|
