May 29th, 2009
Data Definition Language, DROP TABLE
Posted by
admin in
Q. Data Definition Language
ou use a DROP TABLE command to delete a table.
Format:
DROP TABLE table_name;
> If you DROP a table, it means that you lose all of the table’s structure and parameters.
> Some RDBMS systems will not allow you to DROP a table referenced by a FOREIGN KEY until the FOREIGN KEY constraint or the table containing the FOREIGN KEY constraint has been removed.
> Dropping a table does not remove a view, but a view can not function without a base table.
> A table can be empty (no data) without being dropped.
Comments Off
