Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 find unique key constraint in sql server mgmt

Author  Topic 

MyronCope
Starting Member

46 Posts

Posted - 2008-01-15 : 11:39:50
i just got an error in my application when i tried to do an insert stating that there was a "unique key constraint".
I have the database open with sql server management studio and i need to find out how to view the constraints?

How do i navigate to see the constraints on a table?
Thanks

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-01-15 : 11:48:15
sp_helpconstraint 'table'

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -