Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE Table DROP CONSTRAINT [PK_Table]
- CREATE CLUSTERED INDEX [IX_Clustered] ON [Table]
- (
- [a] ASC,
- [b] ASC,
- [c] ASC,
- [d] ASC,
- [e] ASC,
- [f] ASC
- )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]
- ALTER TABLE Table ADD CONSTRAINT
- PK_hands PRIMARY KEY NONCLUSTERED
- (
- e,
- h
- ) 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