drop create table sql code example

Example 1: sql drop table

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

Example 2: table drop if exist sql server

IF OBJECT_ID('dbo.Scores', 'U') IS NOT NULL DROP TABLE dbo.Scores;

Example 3: drop a table

DROP TABLE table_name;