When you destroy a table, you implicitly destroy the constraints on that table. Therefore, if you want to remove a table constraint from the database, use the DROP TABLE command:

Example 5-24. Removing a Constraint

  DROP TABLE 


table_name

Warning Warning
 

Performing the DROP TABLE command will cause you to lose all information stored in that table. You should make sure that all of the data stored in that table is no longer needed.

Instead of dropping a table, you can modify a column constraint by using the ALTER TABLE command.

Help us make a better book, leave feedback. (http://www.opendocspublishing.com/entry.lxp?lxpe=92)