The syntax of the DROP TABLE statement : DROP TABLE « Table « SQL Server / T-SQL Tutorial






DROP TABLE table_name




29> CREATE TABLE customer
30> (
31> name         char(30),
32> phone        char(12),
33> emp_id       char(4)
34> )
35> GO
1>
2> drop table customer;
3> GO
1>








3.5.DROP TABLE
3.5.1.The syntax of the DROP TABLE statement
3.5.2.Check table existance before dropping