how to delete table sql code example

Example 1: delete table sql

DROP TABLE table_name;

Example 2: sql drop table

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

Example 3: how to delete a table data in sql

DELETE FROM table_name; //will delete the table data without affecting the table structue

Example 4: sql delete table

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

Example 5: delete table

DROP TABLE table_name;