Editing constraint

[scklifasovskiy]

Hi all,
I have a table with constraint primary key "a,b,c". Now I need to change it to "a,b,c,d". So no problem -- i drop and create again. My question is -- how can I find out if it exists and what is a value? (i don't want a client to run script each time, want to do it only once)

 

[bborissov]

Check

http://stackoverflow.com/questions/3930338/sql-server-get-table-primary-key-using-sql-query

Borislav Borissov
VFP9 SP2, SQL Server

 

[scklifasovskiy]

thank you ...i did and it helped...