Sql Drop Table and truncate table Statement

Drop Table

The DROP TABLE statement is used to delete a table.

To drop a table, we will use the following syntax:

DROP TABLE table_name

Example:

DROP TABLE articles;

Truncate Table

If you want to delete all data inside the table, you can use truncate table statement

syntax:

TRUNCATE TABLE table_name

Example:

TRUNCATE TABLE articles

Bookmark This Page

Link Partners