USE UFDATA_036_2018 DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR
SELECT Table_Schema+''.''+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 |