Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

Dropping Tables

The DROP TABLE statement is used to drop tables. The following statement drops the BOOKS table:

DROP TABLE books 

The table you want to drop may be referenced by a FOREIGN KEY constraint.

The CASCADE CONSTRAINTS option drops the FOREIGN KEY constraints of the child tables. For example,

DROP TABLE books CASCADE CONSTRAINTS 

To generate the CASCADE CONSTRAINTS option for Oracle


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.