DECLARE Tables CURSOR FOR SELECT DISTINCT QUOTENAME(TABLE_CATALOG) + '.' + QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' OPEN Tables DECLARE @table varchar(128) FETCH NEXT FROM Tables INTO @table WHILE @@FETCH_STATUS = 0 BEGIN PRINT 'Reindexing table ' + ISNULL(@table, '') IF @table IS NOT NULL BEGIN DELETE FROM @table END FETCH NEXT FROM Tables INTO @table END CLOSE Tables DEALLOCATE Tables