Difference between revisions of "REINDEX DATABASE"
Yvonne.milne (Talk | contribs) |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Rebuilds the indexes for each table in the active database or rebuilds the catalog index tags for a specified database | Rebuilds the indexes for each table in the active database or rebuilds the catalog index tags for a specified database | ||
− | |||
==Syntax== | ==Syntax== | ||
− | REINDEX DATABASE [<database name> | + | REINDEX DATABASE [<database name>] |
− | + | ||
==See Also== | ==See Also== | ||
− | [[ADATABASES()]], [[ALTER INDEX]], [[ALTER TABLE | + | [[ADATABASES()]], [[ALTER INDEX]], [[ALTER TABLE]], [[CLOSE DATABASES]], [[CLOSE TABLES]], [[COMPILE DATABASE]], [[COPY DATABASE]], [[CREATE DATABASE]], [[CREATE INDEX]], [[CREATE TABLE]], [[CREATE VIEW]], [[DBUSED()]], [[DISPLAY DATABASE]], [[DISPLAY INDEXES]], [[DISPLAY SCHEMAS]], [[DISPLAY TABLES]], [[DROP DATABASE]], [[DROP INDEX]], [[DROP TABLE]], [[GETENV()]], [[INDEX]], [[ISEXCLUSIVE()]], [[LIST DATABASE]], [[LIST INDEXES]], [[LIST SCHEMAS]], [[LIST TABLES]], [[OPEN DATABASE]], [[PACK DATABASE]], [[REBUILD DATABASE]], [[SET AUTOCATALOG]], [[SET EXCLUSIVE]], [[SQL USE|USE]] |
− | + | ||
==Description== | ==Description== | ||
The REINDEX DATABASE command rebuilds the indexes for each table in the active database. | The REINDEX DATABASE command rebuilds the indexes for each table in the active database. | ||
− | + | Databases are opened using the OPEN DATABASE command. | |
− | If the <database name> is specified, the REINDEX DATABASE command will operate on the specified database's catalog file: the catalog's index tags will be rebuilt | + | If the <database name> is specified, the REINDEX DATABASE command will operate on the specified database's catalog file: the catalog's index tags will be rebuilt. |
+ | If the database is open, it must be open in exclusive mode. | ||
==Example== | ==Example== | ||
Line 27: | Line 25: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
− | |||
[[Category:Lianja VFP Extensions]] | [[Category:Lianja VFP Extensions]] | ||
[[Category:VFP Command Extensions]] | [[Category:VFP Command Extensions]] |
Latest revision as of 11:09, 15 February 2023
Contents
Purpose
Rebuilds the indexes for each table in the active database or rebuilds the catalog index tags for a specified database
Syntax
REINDEX DATABASE [<database name>]
See Also
ADATABASES(), ALTER INDEX, ALTER TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), INDEX, ISEXCLUSIVE(), LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, USE
Description
The REINDEX DATABASE command rebuilds the indexes for each table in the active database.
Databases are opened using the OPEN DATABASE command.
If the <database name> is specified, the REINDEX DATABASE command will operate on the specified database's catalog file: the catalog's index tags will be rebuilt.
If the database is open, it must be open in exclusive mode.
Example
open database southwind reindex database close databases reindex database southwind