REBUILD DATABASE

From Lianjapedia
Revision as of 05:24, 11 July 2018 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Rebuilds a database catalog

Syntax

REBUILD DATABASE [<database name>]

See Also

ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CHECK DATABASE, CHECK TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DATABASE(), DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), INDEX, LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK, PACK DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, USE

Description

The REBUILD DATABASE command rebuilds the catalog for the active or specified database. This packs the catalog file and rebuilds its index tags. All valid programs, tables and known associated indexes from the database's directory are added into the catalog.

Databases are opened using the OPEN DATABASE command.

Example

open database southwind
rebuild database
close database
rebuild database southwind
rebuild database ?