SQL- Delete Table

Delete Table

DELETE Statement is used to delete / remove existing records or records of the entire table from the table.

Syntax :- 

For Specific Record :- 

DELETE FROM table_name WHERE condition;

Example : I will show how to delete specific record in table.

Query :

DELETE FROM my_tab WHERE Name="Vikas";

Output :-

For ALL Records :-

Syntax :-  

DELETE FROM TBName;

Example : Let's take a example to delete table in the database.

Query :

 DELETE  FROM my_tb;

Output :