MSSQL Table Reindex

December 25, 2009 at 1:15 am · Filed under Comptuers, Programming, SQL, Windows

Use this single line command to re-index every table in a Microsoft SQL Server database:

EXEC sp_msForEachTable
  @COMMAND1 = 'DBCC DBREINDEX ("?")'

Leave a Comment