.lf 1 sql/drop.cmdsrc
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
.\" $Header: /usr/local/devel/pglite/cvs/src/doc/ref/sql/drop.cmdsrc,v 1.1 1996/02/24 01:17:01 jolly Exp $
.TH DROP TABLE COMMANDS 11/05/95
.XA 2 "Drop Table"
.SH NAME
drop table \(em destroy existing classes
.SH SYNOPSIS
.(l M
\fBdrop table\fR classname-1 { \fB,\fR classname-i }
.)l
.SH DESCRIPTION
.BR "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 
.IR delete (commands).
.PP
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.
.PP
The destruction of classes is not reversable.  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.
.SH EXAMPLE
.(C
--
--Destroy the emp class
--
drop table emp
.)C
.(C
--
--Destroy the emp and parts classes
--
drop table emp, parts
.)C
.SH "SEE ALSO"
delete(commands),
drop index(commands).