REMOVE TABLE

From Lianjapedia
Jump to: navigation, search

Purpose

Remove the specified table from the currently active database

Syntax

REMOVE TABLE <table>

See Also

ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE TABLE, CREATE INDEX, CREATE VIEW, 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, SET AUTOCATALOG, SET DATADIR, SET EXCLUSIVE, USE

Description

The REMOVE TABLE command is used to remove a table from the currently active database.

Keywords Description
table This is the name of the table to be removed from the database.

Example

CREATE TABLE freetable (freeid char(10))
open database southwind
ADD TABLE freetable
list files
REMOVE TABLE freetable