GNU/Linux |
RedHat 5.2(Apollo) |
|
drop_table(l) |
drop table - destroy existing classes
drop table classname-1 { , classname-i }
Drop Table removes classes from the data base. Only its owner may destroy a class. A class may be emptied of instances, but not destroyed, by using delete(l).
If a class being destroyed has secondary indices on it, then they will be removed first. The removal of just a secondary index will not affect the indexed class.
The destruction of classes is not reversible. Thus, a destroyed class will not be recovered if a transaction which destroys this class fails to commit. In addition, historical access to instances in a destroyed class is not possible.
--
--Destroy the emp class
--
drop table emp
--
--Destroy the emp and parts classes
--
drop table emp, parts
delete(l), drop aggregate(l), drop database(l), drop function(l), drop index(l), drop operator(l), drop rule(l), drop sequence(l), drop trigger(l), drop type(l), drop view(l).
drop_table(l) |