4. Maintaining a Distributed Database : Drop Statement : Drop Table Statement
Share this page                  
Drop Table Statement
The drop table statement has the following format:
drop [table] table_name
Use this statement on table objects created by the create table statement at the Ingres Star level. It removes the actual table, its registration, and all its data, as well as the description of the table in the Ingres Star catalogs.
Important!  Use the drop statement with care because this statement destroys objects. All dependent objects, for example, views and indexes, are also dropped.