Create/ drop unique key

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

grahams-701143 SSC Rookie Points: 44 More actions · Answer 1

You can get rid of the need for the cursor

SELECT @r=@R+column_name+',' from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where constraint_name =@uq_name

G

Douglas Osborne-456728 SSCommitted Points: 1569 More actions · Answer 2

I agree - any time I see a CURSOR declaration in the first few lines of code...

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

SSC Guru

Points: 76202

May 24, 2016 at 6:49 am

Thanks for the script.