Skip to Main Content
SQL in a Nutshell
book

SQL in a Nutshell

by Kevin Kline
December 2000
Intermediate to advanced content levelIntermediate to advanced
224 pages
9h 52m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell

Name

DROP TABLE

Synopsis

This command removes a table definition and all data, indexes, triggers, constraints, and permission specifications for that table. Any view or stored procedure that references the dropped table encounters problems, unless they are explicitly altered or dropped as well.

Some vendors do not allow a table to be dropped unless certain other characteristics of the table are dropped first. For example, Microsoft SQL Server requires that the table be dropped from any replication scheme and FOREIGN KEY references be dropped before the table itself is dropped.

Vendor

Command

SQL Server

Supported, with variations

MySQL

Supported, with variations

Oracle

Supported, with variations

PostgreSQL

Supported, with variations

SQL99 Syntax and Description

DROP TABLE table_name RESTRICT | CASCADE

In the SQL99 syntax, RESTRICT prohibits the DBMS from executing the command if views or constraints currently reference the table to be dropped. The CASCADE clause causes any referencing objects to be dropped along with the table.

Microsoft SQL Server Syntax and Variations

DROP TABLE [database_name.][owner_name.]table_name [,...n]
GO

Microsoft SQL Server allows more than one table to be dropped at a time by including a comma between each table name. Tables also may be dropped in databases outside of the current context by specifying the database name (assuming the user has the right permissions). Any constraints or triggers on the table are dropped with the table. Explicitly declared ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

Kevin Kline

Publisher Resources

ISBN: 1565927443