ADD TABLE

From Lianjapedia
Jump to: navigation, search

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