Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. declare @create_indexes nvarchar(max);
  2. set @create_indexes = N'';
  3.  
  4. select
  5. @create_indexes = @create_indexes +
  6. 'create clustered index ' + quotename('IX_' + object_name(i.object_id)) +
  7. char(13) + char(10) +
  8. 'on ' + quotename(object_name(i.object_id)) + '(' + quotename(c.name) + ');' +
  9. char(13) + char(10) +
  10. 'go' +
  11. char(13) + char(10)
  12. from sys.indexes i
  13. inner join sys.columns c
  14. on i.object_id = c.object_id
  15. where i.type = 0
  16. and c.is_identity = 1;
  17.  
  18. print @create_indexes;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement