DBCC CLEANTABLE reclaims table space after a column is dropped from the database using the ALTER TABLE DROP COLUMN statement. DBCC CLEANTABLE works for variable-length columns only. Variable-length columns are columns of type varchar, text, nvarchar, ntext, varbinary, and image.
Beekeeper Studio Is A Free & Open Source SQL Server GUI
I’ve upgraded from SQL Server and it was a smooth change — Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai
Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.
Syntax
DBCC CLEANTABLE ('MyDatabase', 'MyTable')
You need sysadmin or db_owner privileges to run DBCC CLEANTABLE.
More SQL Server Articles
- 5 Top Free & Open Source SQL Server GUIs for 2026
- 5 Free SSMS Alternatives for 2026 (Open Source, Cross-Platform)
- SQL Server Joins Guide: Inner, Left, Right & Full Joins
- How to Uninstall SQL Server: A Step-by-Step Guide
- How to Create a JDBC SQL Server Connection String
- SQL Server Subtraction Operations
- How to Rename a Column in SQL Server | Easy Step-by-Step Tutorial
- SQL Server Express Edition: Features and Limitations
- SQL Server System Tables and Stored Procedures (SPs)
- Essential SQL Server Performance Counters Guide
- The 4 Pillars of SQL Server Performance: CPU, Memory, Disk I/O, & Cache Hit Ratios
- SQL Server Client Network Utility
- Convert Microsoft Access databases to SQL Server or MSDE
- System Tables and Stored Procedures - SQL Server
- Connecting to SQL Server 2005 and SQL Server Express
- SQL Server Administration
- SQL Server Development and T-SQL
- Understanding DDL triggers in SQL Server 2005
- How To Limit The Number Of Rows Returned In SQL Server
- Migrating changes made to SQL Server databases to production
- Longhorn, Vista to drop SQL Server 2000 and MSDE support
- SQL Server Express and MSDE
- Specified SQL Server not found
- Compare SQL Server 2005 Editions
- SQL Server Utility (SSEUtil) - Essential Features Guide
- Microsoft SQL Server Cursors
- SQL Server Performance Optimization Guide
- OPENROWSET: Import data into SQL Server tables
- View SQL Server Agent job history
- SQL Server 2005 Express: Express Manager, Management Studio, downloads, & limitations
- List available SQL Server instances on the network
- How many rows does your largest SQL Server table contain?
- Microsoft released SQL Server 2005 SP2 CTP
- Verify SQL Server and MSDE Installation
- SQL Server Performance Analysis: Key Monitoring Areas
- SOUNDEX() helps you find that last name
- Not associated with a trusted sql server connection
- xp_fixeddrives: Monitor SQL Server Disk Space Usage
- GO (SQL Server TSQL)
- Tuning tempdb For Better SQL Server Performance
- SSAS Tutorial: Building SQL Server Analysis Services Cubes
- SQL Server Data Manipulation Language (DML)
- SQL Server Data Types and Ranges
- Guide to SQL Server Backup Types and Recovery Options
- Advantages of SQL Server 64-bit Architecture
- sp_configure: Limit SQL Server memory usage
- Detect Duplicate Rows in a SQL Server Table
- Comments (SQL Server)
- SQL Server Performance Optimization Tips
- Understanding VARCHAR(MAX) in SQL Server 2005 & 2008
- Understanding SQL Server Memory Internals & Cache
- Understanding SQL Server Blocking and Deadlocks
- How to Import CSV Data into SQL Server Tables with BULK INSERT
- How (Any Why) To Add Source Control To SQL Server
- How to Drop a Constraint in SQL Server