[SQL] Reorganize every table in every schema in a database.

Database Table Reorg.sql

USE --DATABASE NAME
 
  
 
DECLARE @TableName varchar(255) 
DECLARE @TableSchema varchar(255) 
DECLARE @FULLNAME varchar(512)
  
 
DECLARE TableCursor CURSOR FOR 
 
SELECT table_name, table_schema  FROM information_schema.tables 
 
WHERE table_type = 'base table' 
 
  
 
OPEN TableCursor 
 
  
 
FETCH NEXT FROM TableCursor INTO @TableName, @TableSchema 
 
WHILE @@FETCH_STATUS = 0 
 
BEGIN 
SET @FULLNAME =  @TableSchema + '.' + @TableName
DBCC DBREINDEX(@FULLNAME,' ',90) 
 
FETCH NEXT FROM TableCursor INTO @TableName, @TableSchema 
 
END 
 
  
 
CLOSE TableCursor 
 
  
 
DEALLOCATE TableCursor