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]
Transact-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 in the statement. Since Transact-SQL does not support this, these keywords are not generated during transformation.
Adaptive Server/CIS passes the drop table command to the DirectConnect server as a language event.