Difference between revisions of "REMOVE TABLE"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by one other user not shown) | |||
Line 11: | Line 11: | ||
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" width="100%" |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
Line 31: | 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