Click here to Skip to main content
15,892,517 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
SQL
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[SortCodes]') AND name = N'PK_SortCodes_1')
ALTER TABLE [dbo].[SortCodes] DROP CONSTRAINT [PK_SortCodes_1]
GO

ALTER TABLE [dbo].[SortCodes_BCP] ADD  CONSTRAINT [PK_SortCodes_1] PRIMARY KEY CLUSTERED
(
    [ID] ASC,
    [Sortcode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
Posted
Updated 21-Dec-13 6:47am
v2
Comments
ZurdoDev 21-Dec-13 22:27pm    
What?
Andrius Leonavicius 25-Dec-13 8:58am    
Hi,

May I ask what exactly you are trying to achieve here?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900