diff options
Diffstat (limited to 'doc/man/drop.l')
| -rw-r--r-- | doc/man/drop.l | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/doc/man/drop.l b/doc/man/drop.l new file mode 100644 index 00000000000..d57bca0d3b4 --- /dev/null +++ b/doc/man/drop.l @@ -0,0 +1,41 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/doc/man/Attic/drop.l,v 1.1.1.1 1996/08/18 22:14:23 scrappy Exp $ +.TH "DROP TABLE" SQL 11/05/95 Postgres95 Postgres95 +.SH NAME +drop table \(em destroy existing classes +.SH SYNOPSIS +.nf +\fBdrop table\fR classname-1 { \fB,\fR classname-i } +.fi +.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 (l). +.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 +.nf +-- +--Destroy the emp class +-- +drop table emp +.fi +.nf +-- +--Destroy the emp and parts classes +-- +drop table emp, parts +.fi +.SH "SEE ALSO" +delete(l), +drop index(l). |