Sunday 30 March 2014

SQL: DROP TABLE STATEMENT


The SQL DROP TABLE statement with examples.

DESCRIPTION: SQL DROP TABLE statement allows to remove or delete a table from the SQL database.

SYNTAX
DROP TABLE table_name;

table_name is the name of the table to remove from the database.


EXAMPLE
An example shows how to drop a table using the SQL DROP TABLE statement.

For example:
DROP TABLE employee;

DROP TABLE statement example would drop the table called employee.


No comments:

Post a Comment