Showing UNIQUE KEY on SSMS 2012 Diagram

Question

Is there a way to display UNIQUE KEY label? Thanks.

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 1

Hi

This should give you all the information requested.

SELECT * 
FROM   INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab
    , INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col
WHERE  Col.Constraint_Name=Tab.Constraint_Name
      AND Col.Table_Name=Tab.Table_Name
      AND Constraint_Type<>'UNIQUE'
      AND Col.Table_Name='Table name'

Hope this helps

edit: oops just realised you meant in the diagrams...