delete table sql code example

Example 1: delete table sql

DROP TABLE table_name;

Example 2: query to empty table data in sql server

TRUNCATE TABLE  table_name;

Example 3: sql drop table

-- Drop, but no space gain
DROP TABLE table_name;
-- Really frees space (Oracle)
DROP TABLE table_name PURGE;

Example 4: sql delete

DELETE FROM table_name WHERE condition;
-- 			Ex.
DELETE FROM Customers WHERE CustomerName='Mustafa Mbari';

Example 5: sql delete table

Deletes a table from a database.
Example: Removes the users table.
DROP TABLE users;

Example 6: delete table

DROP TABLE table_name;