COMPILE DATABASE Command
Compiles stored procedures in a database.
COMPILE DATABASE DatabaseName | FileSkeleton | ?
- Specifies that the file to compile is a database file (.dbc). Source code for stored procedures saved with the database is compiled and stored in an additional memo field.
- Specifies the name of the database containing the stored procedures to compile. You can compile stored procedures in a database that is not open.
- Specifies a subset of database files to compile. cFileSkeleton is a file specification skeleton that supports wildcards such as * and ?. For example, to compile all database files that begin with A, use the following command:
COMPILE DATABASE A*
Use COMPILE DATABASE to compile stored procedures outside the Database Designer. Stored procedures can be created and modified interactively with MODIFY PROCEDURES, or programmatically with APPEND PROCEDURES.
COMPILE DATABASE packs memo fields in the .dct memo file for the database to remove unused space from the memo file. Records marked for deletion in the database table aren't removed from the table.
The following example compiles all stored procedures in the
CLOSE DATABASES COMPILE DATABASE (HOME(2) + 'data\testdata')