Difference between revisions of "REMOVE TABLE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(4 intermediate revisions by 3 users not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ADATABASES()]], [[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], | + | [[ADATABASES()]], [[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CLOSE TABLES]], [[COMPILE DATABASE]], [[CREATE DATABASE]], [[CREATE TABLE]], [[CREATE INDEX]], [[CREATE VIEW]], [[DATABASE()]], [[DBUSED()]], [[DISPLAY DATABASE]], [[DISPLAY INDEXES]], [[DISPLAY TABLES]], [[DROP DATABASE]], [[DROP INDEX]], [[DROP TABLE]], [[GETENV()]], [[LIST DATABASE]], [[LIST INDEXES]], [[LIST TABLES]], [[OPEN DATABASE]], [[PACK DATABASE]], [[REBUILD DATABASE]], [[REINDEX DATABASE]], [[SET AUTOCATALOG]], [[SET DATADIR]], [[SET EXCLUSIVE]], [[SQL USE|USE]] |
==Description== | ==Description== | ||
The REMOVE TABLE command is used to remove a table from the currently active database. | The REMOVE TABLE command is used to remove a table from the currently active database. | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
Line 18: | Line 17: | ||
|- | |- | ||
|} | |} | ||
− | |||
− | |||
− | |||
==Example== | ==Example== | ||
Line 35: | Line 31: | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
− |
Latest revision as of 10:49, 4 February 2013
Contents
Purpose
Remove the specified table from the currently active database
Syntax
REMOVE TABLE <table>
See Also
ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE TABLE, CREATE INDEX, CREATE VIEW, DATABASE(), DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), LIST DATABASE, LIST INDEXES, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET DATADIR, SET EXCLUSIVE, USE
Description
The REMOVE TABLE command is used to remove a table from the currently active database.
Keywords | Description |
---|---|
table | This is the name of the table to be removed from the database. |
Example
CREATE TABLE freetable (freeid char(10)) open database southwind ADD TABLE freetable list files REMOVE TABLE freetable