SQL Drop Table

SQL drop table is used to remove or delete an existing table from a SQL database. Deleting a table will cause loss of all information stored in the table.

Drop Table Syntax :

The syntax of the Drop Table is −

DROP TABLE table-name;

Drop Table Example :

DROP TABLE Customer;

SQL Truncate Table

The Truncate TABLE statement is used to delete data inside a table, but not on the table itself.

Truncate Table Syntax :

The syntax of the Truncate Table is −

TRUNCATE TABLE table-name;



Visit :


Discussion


* You must be logged in to add comment.