Compiles stored procedures in a database.
Syntax
COMPILE DATABASE DatabaseName
Arguments
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.
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.