Difference between revisions of "ADD TABLE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
| Line 6: | Line 6: | ||
==See Also== | ==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]], [[SQL USE|USE]] | + | [[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== | ||
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
