SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Michaël Hardman / Create/ drop unique key / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 22:22:53 GMT20RE: Create/ drop unique keyhttp://www.sqlservercentral.com/Forums/Topic790211-1657-1.aspxI agree - any time I see a CURSOR declaration in the first few lines of code...Fri, 25 Sep 2009 08:37:26 GMTDouglas Osborne-456728RE: Create/ drop unique keyhttp://www.sqlservercentral.com/Forums/Topic790211-1657-1.aspxYou can get rid of the need for the cursorSELECT @R=@R+column_name+',' from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where constraint_name =@uq_nameGThu, 24 Sep 2009 06:26:14 GMTgrahams-701143Create/ drop unique keyhttp://www.sqlservercentral.com/Forums/Topic790211-1657-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Create/68184/">Create/ drop unique key</A>[/B]Fri, 18 Sep 2009 03:44:55 GMTmi_ka_ze