When I am working with an Oracle database, I still find myself using SQL ... this simple query shows the constraints for a given table that are foreign key constraints and which primary key ...

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.