Rebuild All Indexes for All Tables

DECLARE @TableName NVARCHAR(MAX)
DECLARE @SQL NVARCHAR(MAX)

DECLARE TableCursor CURSOR FOR
SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + ‘.’ + QUOTENAME(name)
FROM sys.tables

OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = ‘ALTER INDEX ALL ON ‘ + @TableName + ‘ REBUILD’
EXEC sp_executesql @SQL

FETCH NEXT FROM TableCursor INTO @TableName

END

CLOSE TableCursor
DEALLOCATE TableCursor