SqlCeEngine.Shrink Method

Reclaims wasted space in the SQL Server Compact database by moving empty pages to the end of the file, and then truncating the file.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public Sub Shrink
'Usage
Dim instance As SqlCeEngine

instance.Shrink()
public void Shrink()
public:
void Shrink()
member Shrink : unit -> unit 
public function Shrink()

Remarks

Unlike the Compact method, the Shrink method does not create a temporary database file. Instead, all empty and unallocated pages are moved to the end of the file and are then truncated, reducing the overall database size.

You can configure a database to automatically shrink by setting the AutoShrink() property on the database.

Examples

Dim engine As New SqlCeEngine("Data Source = AdventureWorks.sdf")
engine.Shrink()
SqlCeEngine engine = new SqlCeEngine("Data Source = AdventureWorks.sdf");
engine.Shrink();

See Also

Reference

SqlCeEngine Class

System.Data.SqlServerCe Namespace