diff options
| author | Marc G. Fournier | 1996-11-14 10:18:14 +0000 |
|---|---|---|
| committer | Marc G. Fournier | 1996-11-14 10:18:14 +0000 |
| commit | 7ac541daf1b0bba6274f280eedba01166f97cbe8 (patch) | |
| tree | 14015895f470ce0846df3bc9dd117ecf7fd6bfd6 /src/man/drop.l | |
| parent | 389fe48cbb513888205bbe3a5008ed109976dacb (diff) | |
moved man pages here, as requested by Bryan
Diffstat (limited to 'src/man/drop.l')
| -rw-r--r-- | src/man/drop.l | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/src/man/drop.l b/src/man/drop.l new file mode 100644 index 0000000000..ccf42efdf4 --- /dev/null +++ b/src/man/drop.l @@ -0,0 +1,41 @@ +.\" This is -*-nroff-*- +.\" XXX standard disclaimer belongs here.... +.\" $Header: /cvsroot/pgsql/src/man/Attic/drop.l,v 1.1 1996/11/14 10:16:43 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). |
