DDL-Drop

nIndexes, tables, and databases can easily be deleted/removed with the DROP statement.

Syntax:

DROP table table_name

Query:

DROP table EMPtb1

DROP DATABASE Employee_db

NOTE:

nWhat if we only want to delete the data inside the table, and not the table itself?

nThen, use the TRUNCATE TABLE statement

Query:

TRUNCATE TABLE EMPtbl1