Difference between revisions of "ADD TABLE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 17: | Line 17: | ||
|- | |- | ||
|} | |} | ||
+ | |||
+ | Note: [http://www.lianja.com/community/showthread.php?3389-Adding-a-table-to-a-Database&p=15523&viewfull=1#post15523 See here for more information on adding a table to a database.] | ||
==Example== | ==Example== |
Revision as of 05:19, 11 March 2016
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. |
Note: See here for more information on adding a table to a database.
Example
CREATE TABLE freetable (freeid char(10)) open database southwind ADD TABLE freetable