Difference between revisions of "REMOVE TABLE"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) |
||
| 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" | {| class="wikitable" | ||
| Line 18: | Line 17: | ||
|- | |- | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
==Example== | ==Example== | ||
Revision as of 13:17, 19 December 2012
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
