[dba-SQLServer] Where are foreign key constraints?

jwcolby jwcolby at colbyconsulting.com
Mon Feb 28 17:58:15 CST 2011


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


More information about the dba-SQLServer mailing list