Share via

COMPILE DATABASE Command

  • Article

Compiles stored procedures in a database.

COMPILE DATABASE DatabaseName | FileSkeleton | ?

Parameters

  • DATABASE
    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.

  • DatabaseName
    Specifies the name of the database containing the stored procedures to compile. You can compile stored procedures in a database that is not open.

  • cFileSkeleton
    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*

Remarks

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.

Example

The following example compiles all stored procedures in the testdata database.

CLOSE DATABASES
COMPILE DATABASE (HOME(2) + 'data\testdata')

See Also

APPEND PROCEDURES | COPY PROCEDURES | CREATE TRIGGER | DISPLAY PROCEDURES | MODIFY PROCEDURE | OPEN DATABASE