Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment