drop table

Description

Removes a table definition and all of its data, indexes, triggers, and authorization specifications from the database.

Syntax

drop table [[database.]owner.]table_name

Parameters

table_name

is the name of the table to be dropped.

Examples

Example 1

drop table authors

Usage

• • 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 DirectConnect for z/OS as a language event.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF