Removes a table definition and all of its data, indexes, triggers, and authorization specifications from the database.
drop table [[database.]owner.]table_name
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 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.
