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();