Difference between revisions of "ADD TABLE"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→See Also) |
|||
| (12 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Add the specified table to the currently active database | Add the specified table to the currently active database | ||
| − | |||
==Syntax== | ==Syntax== | ||
ADD TABLE <table> | ADD TABLE <table> | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[ADATABASES()]], [[ALTER INDEX]], [[ALTER TABLE | + | [[ADATABASES()]], [[ALTER INDEX]], [[ALTER TABLE]], [[CLOSE TABLES]], [[COMPILE DATABASE]], [[COPY TABLE]], [[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]], [[RENAME]], [[RENAME Commands]], [[SET AUTOCATALOG]], [[SET DATADIR]], [[SET EXCLUSIVE]], [[SQL USE|USE]] |
| − | + | ||
==Description== | ==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. | 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. | ||
| − | + | {| class="wikitable" width="100%" | |
| − | + | ||
| − | {| class="wikitable" | + | |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
| Line 23: | Line 18: | ||
|} | |} | ||
| − | + | 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== | ||
| Line 34: | Line 27: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
| − | |||
Latest revision as of 12:27, 20 November 2023
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, COPY TABLE, 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, RENAME, RENAME Commands, 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
