Script for rebuilding all table indexes in SQL Server

gistfile1.sql

-- http://gallery.technet.microsoft.com/scriptcenter/Script-for-rebuilding-all-8d079754
USE DatabaseName --Enter the name of the database you want to reindex


DECLARE @TableName varchar(255)

 

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM information_schema.tables

WHERE table_type = 'base table'

 

OPEN TableCursor

 

FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

DBCC DBREINDEX(@TableName,' ',90)

FETCH NEXT FROM TableCursor INTO @TableName

END

 

CLOSE TableCursor

 

DEALLOCATE TableCursor