From 7ac541daf1b0bba6274f280eedba01166f97cbe8 Mon Sep 17 00:00:00 2001 From: Marc G. Fournier Date: Thu, 14 Nov 1996 10:18:14 +0000 Subject: moved man pages here, as requested by Bryan --- src/man/drop.l | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 src/man/drop.l (limited to 'src/man/drop.l') 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). -- cgit v1.2.3