ADD TABLE
From Lianjapedia
Revision as of 12:59, 19 December 2012 by Yvonne.milne (Talk | contribs)
Contents
Purpose
Add the specified table to the currently active database
Syntax
ADD TABLE <table>
See Also
ADATABASES(), ALTER INDEX, ALTER TABLE, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE TABLE, CREATE INDEX, 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, REMOVE TABLE, SET AUTOCATALOG, SET DATADIR, SET EXCLUSIVE, USE
Description
The ADD TABLE command is used to add an existing table to the currently active database. If no database is currently active an error will be generated.
Keywords | Description |
---|---|
table | This is the name of the table to be added to the database. |
Example
CREATE TABLE freetable (freeid char(10)) open database southwind ADD TABLE freetable