Script para reindexar tabelas em um banco SQL Server

DECLARE @NomeTabela varchar(50)

DECLARE CURSOR_TABLES CURSOR
FOR SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE INFORMATION_SCHEMA.TABLES.TABLE_TYPE = 'BASE TABLE'

OPEN CURSOR_TABLES

FETCH NEXT FROM CURSOR_TABLES INTO @NomeTabela

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @NomeTabela
DBCC DBREINDEX(@NomeTabela)

FETCH NEXT FROM CURSOR_TABLES INTO @NomeTabela
END
CLOSE CURSOR_TABLES
DEALLOCATE CURSOR_TABLES