DROP TABLE

To delete a table from database, we use DROP TABLE statement 

Syntax:

DROP TABLE table_name;

Example: To delete ‘students’ table.

DROP TABLE students;

Note -> The DROP TABLE statement will fully delete the table from database.

But there is a statement TRUNCATE TABLE which will delete the data from table remaining the schema as it is.

TRUNCATE TABLE

Syntax:

TRUNCATE TABLE table_name;

Example:

TRUNCATE TABLE students;
September 6, 2022 by SQL