![]() |
SQL-J Language Reference
|
Reference Manual |
DROP TABLE statementDROP TABLE removes the specified table. SyntaxDROP TABLE TableName ExampleDependency SystemIf there is an open cursor or a view that uses the table being dropped, then the DROP TABLE statement generates an error and does not drop the table. Dropping a table invalidates other statements that depend on the table. When a table is dropped, all triggers on that table are automatically dropped. (You don't have to drop a table's triggers before dropping the table.) |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |