Difference between revisions of "SET AUTOCATALOG"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 26: | Line 26: | ||
[[Category:Set_Commands|AUTOCATALOG]] | [[Category:Set_Commands|AUTOCATALOG]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
− | |||
[[Category:Lianja VFP Extensions]] | [[Category:Lianja VFP Extensions]] | ||
[[Category:VFP Command Extensions]] | [[Category:VFP Command Extensions]] |
Latest revision as of 06:31, 4 February 2013
Contents
Purpose
Enable files to be automatically added to a database catalog
Syntax
SET AUTOCATALOG ON | OFF | (<expL>)
SET AUTOCATALOG TO <database>
See Also
ADATABASES(), ADD TABLE, 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, LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET EXCLUSIVE, USE
Description
The SET AUTOCATALOG commands allow tables and their index files to be automatically added to a database catalog. The database itself should be closed when using the auto catalog commands. The SET AUTOCATALOG TO <database> command specifies the name of the database for which the catalog should be updated. SET AUTOCATALOG ON | OFF allows updates to the catalog to be toggled on and off. Once the auto catalog commands are active, tables and their indexes can be opened from the interactive prompt or from an application and the database catalog will automatically be updated. For additional details on the information stored in the database catalog, please see the OPEN DATABASE command.
Databases are opened using the OPEN DATABASE command.
Example
close databases set autocatalog to southwind set autocatalog on do myapp