[dba-SQLServer] Where are foreign key constraints?

Michael Maddison michael at ddisolutions.com.au
Mon Feb 28 18:26:03 CST 2011

Hi John,


In 2005, in diagram, right click the table and select relationships.

You should see the FK's for that table.

In object explorer, expand Tables, expand Keys...




Michael M



From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, 1 March 2011 10:58 AM
To: Sqlserver-Dba
Subject: [dba-SQLServer] Where are foreign key constraints?


I built a database diagram where i dragged and dropped my PKs out onto
FKs.  Now I am getting error
messages like:

The insert statement conflicted with the foreign key constraint...

I look at the constraints folder in each table and there is no FK_
constraints listed.  I assume
that they are stored somewhere else?  Am I doing something wrong

John W. Colby
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com


No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1435/3474 - Release Date: 02/28/11

More information about the dba-SQLServer mailing list