solidDB Help : solidDB reference : SQL: Statements : DROP TABLE
  
DROP TABLE
DROP TABLE [[catalog‑name.]schema‑name.]table‑name [CASCADE [CONSTRAINTS]]
Access requirements
Database user
Usage
Use the DROP TABLE statement to remove a table from the database.
Parameters, clauses, keywords, and variables
CASCADE or CASCADE CONSTRAINTS: All referential integrity constraints that refer to primary and unique keys in the dropped table are removed. This means that all the foreign keys specifications are removed from tables that reference the table being dropped. However, no column values are changed in the referencing tables.
If the CASCADE keyword is not used and the statement execution would violate referential integrity constraints, the statement fails, with the following exceptions:
If your table has a synchronization history table, that synchronization history table is dropped automatically.
If your table has indexes on it, you do not need to drop the indexes first; they are dropped automatically when the table is dropped.
If a view or a stored procedure references your table, your table is dropped, and the view or stored procedure fails the next time that it tries to reference the table.
Examples
DROP TABLE table1;
-- Using catalog, schema, and table name
DROP TABLE domains_db.demand_schema.bad_address_table;
--remove foreign key constraints in referencing tables
DROP TABLE table2 CASCADE CONSTRAINTS;
Go up to
SQL: Statements