Guest User

Untitled

a guest
Jun 24th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. ALTER TABLE Table DROP CONSTRAINT [PK_Table]
  2.  
  3. CREATE CLUSTERED INDEX [IX_Clustered] ON [Table]
  4. (
  5. [a] ASC,
  6. [b] ASC,
  7. [c] ASC,
  8. [d] ASC,
  9. [e] ASC,
  10. [f] ASC
  11. )WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF) ON [PRIMARY]
  12.  
  13. ALTER TABLE Table ADD CONSTRAINT
  14. PK_hands PRIMARY KEY NONCLUSTERED
  15. (
  16. e,
  17. h
  18. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
Add Comment
Please, Sign In to add comment