Export (0) Print
Expand All
Expand Minimize

COMPILE DATABASE Command

Visual Studio .NET 2003

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

Show:
© 2014 Microsoft