Article - CS200415
How to shrink a table in MS SQL Server
Modified: 06-Mar-2015
Applies To
MS SQL Server 2008 and laterDescription
- How to reset the "High Water Mark" (= Oracle) of a table in MS SQL Server
- Many rows have been deleted from a table
- How to shrink the table and rebuild indexes (clustered and non-clustered)
This is a printer-friendly version of Article 200415 and may be out of date. For the latest version click CS200415