[dba-SQLServer] Where are foreign key constraints?

That folder is for general constraints which you create (FieldA > x and FieldB < y)

Table Relationship constraints are not stored there.

Go to Database - Tables - TableName. Right click, select modify.  In the right hand pane, 
right click and select Relationships.

-- 
Stuart



On 28 Feb 2011 at 18:58, jwcolby wrote:

> 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?
> I
> -- 
> 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
> 
>