DROP TABLE (TSQL Statement)

drops the specified table.

Syntax

DROP TABLE <table_qname>

<table_qname> ::= [ database_name. [ schema_name ] . | schema_name. ] table_name

Arguments

<table_qname>

is the qualified or unqualified name of the table to drop.

Remarks

Only sa or dbo is allowed to execute this statement.

Examples

DROP TABLE customers;