Share via


The following methods are supported by the Engine object:

Method

Description

CompactDatabase Method (SQL Server Compact)

The CompactDatabase method compacts and reclaims wasted space in the local Microsoft SQL Server Compact 3.5 database. This method can also be used to change the collating order, encryption, and password settings of the database.

CreateDatabase Method (SQL Server Compact)

The CreateDatabase method creates a new SQL Server Compact 3.5 database.

Repair Method (SQL Server Compact)

The Repair method tries to repair a corrupted database.

ISSCEEngine.UpgradeDatabase (SQL Server Compact)

ISSCEEngine.UpgradeDatabase method upgrades a SQL Server Compact 3.5 database from version 3.1 to version 3.5.

Verify Method (SQL Server Compact)

Recalculates the checksums for each page in the database and compares the new checksums to the expected values.

VerifyEx Method (SQL Server Compact)

Recalculates the checksums for each page in the database and compares the new checksums to the expected values. Checks that each index entry exists in the table and that each table entry exist in the index. This option is slower and more thorough than Verify Method (SQL Server Compact).

Other Resources

Engine Object Programming (SQL Server Compact)