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... cheers 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 somewhere? -- John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.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