Removes a table definition and all of its data, indexes, triggers, and permissions from the database.
Transact-SQL Syntax
drop table [[database.]owner.]table_name [, [[database.]owner.]table_name]...
ODBC Syntax
DROP TABLE base_table_name [CASCADE|RESTRICT]
is the name of the table to be dropped.
drop table authors
T-SQL allows you to drop multiple tables in one statement, but ODBC does not. If multiple tables are encountered, transformation generates multiple DROP statements.
ODBC allows the keywords CASCADE and RESTRICT to be used in the statement. Since T-SQL does not support this, the keywords are not generated during transformation.
ASE/CIS passes the drop table command to the DirectConnect server as a language event.
