SQL Drop Table - How to use DROP command in SQL ? - How to Drop a Table in SQL



Drop a Table in SQL

  • Below is a selection from the wikitechytable table used in the examples:
drop-table-1

The SQL DROP TABLE Statement

  • The DROP TABLE statement is used to drop an existing table in a database.

Syntax

  DROP TABLE  table_name;
  • Note : Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!

SQL DROP TABLE Example

  • The following SQL statement drops the existing table "wikitechytable":
 DROP TABLE  wikitechytable;

Output

drop-table-2

Related Searches to SQL Drop Table - How to use DROP command in SQL ? - How to Drop a Table in SQL