10. Understanding Ingres Management Architecture : MIB Creation : Registration of IMA Tables : REMOVE TABLE Statement--Remove Table Registrations
 
Share this page                  
REMOVE TABLE Statement--Remove Table Registrations
Use the SQL statement REMOVE TABLE to remove the definition of an IMA table. This statement removes all catalog entries for the registered table, including any related views, integrities, and permits.
This statement has the following syntax:
remove table tablename;
where:
tablename
Is the table name for a registered IMA table.