We can remove a relation (base table) and its definition, the relation will no longer be usable as it’s description will no longer exist.
DROP TABLE DEPENDENT;We can optionally only drop the table if not referenced in any constraints:
DROP TABLE DEPENDNET RESTRICT;All constraints that reference table are dropped along with table.
DROP TABLE DEPENDENT CASCADE;