1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
<!-- manual page source format generated by PolyglotMan v3.0.4, -->
<!-- available via anonymous ftp from ftp.cs.berkeley.edu:/ucb/people/phelps/tcltk/rman.tar.Z -->
<HTML>
<HEAD>
<TITLE>"DROP(TABLE") manual page</TITLE>
</HEAD>
<BODY>
<A HREF="sql.html">SQL Reference Contents</A>
<H2><A NAME="sect0" HREF="#toc0">NAME </A></H2>
drop table - destroy existing classes
<H2><A NAME="sect1" HREF="#toc1">SYNOPSIS </A></H2>
<B>drop table </B> classname-1
{ <B>, </B> classname-i } <BR>
<H2><A NAME="sect2" HREF="#toc2">DESCRIPTION </A></H2>
<B>Drop Table</B> 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 <I><A HREF="delete.l.html">delete</I>(l)</A>
. <P>
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. <P>
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.
<H2><A NAME="sect3" HREF="#toc3">EXAMPLE
</A></H2>
-- <BR>
--Destroy the emp class <BR>
-- <BR>
drop table emp <BR>
-- <BR>
--Destroy the emp and parts
classes <BR>
-- <BR>
drop table emp, parts <BR>
<H2><A NAME="sect4" HREF="#toc4">SEE ALSO </A></H2>
<A HREF="delete.l.html">delete(l)</A>
, drop <A HREF="aggregate.l.html">aggregate(l)</A>
,
drop <A HREF="database.l.html">database(l)</A>
, drop <A HREF="function.l.html">function(l)</A>
, drop <A HREF="index.l.html">index(l)</A>
, drop <A HREF="operator.l.html">operator(l)</A>
, drop
<A HREF="rule.l.html">rule(l)</A>
, drop <A HREF="sequence.l.html">sequence(l)</A>
, drop <A HREF="trigger.l.html">trigger(l)</A>
, drop <A HREF="type.l.html">type(l)</A>
, drop <A HREF="view.l.html">view(l)</A>
.
<P>
<HR><P>
<A NAME="toc"><B>Table of Contents</B></A><P>
<UL>
<LI><A NAME="toc0" HREF="#sect0">NAME</A></LI>
<LI><A NAME="toc1" HREF="#sect1">SYNOPSIS</A></LI>
<LI><A NAME="toc2" HREF="#sect2">DESCRIPTION</A></LI>
<LI><A NAME="toc3" HREF="#sect3">EXAMPLE</A></LI>
<LI><A NAME="toc4" HREF="#sect4">SEE ALSO</A></LI>
</UL>
</BODY></HTML>
|
