Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
COMPILE DATABASE Command
Collapse the table of content
Expand the table of content

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:
© 2015 Microsoft