4. Maintaining a Distributed Database : Drop Statement : Example: Drop Table
 
Share this page                  
Example: Drop Table
To remove the registration of corp_dept from the distributed database and the table itself from the local database, west_usa, use the following command:
drop table corp_dept;
To drop the table named World Wide Sales, delimit the table name:
drop table "World Wide Sales";