You can query this view by specifying the name of the table and the type of the constraint. Here is an example of viewing the primary and foreign keys of the CUSTOMER table: SELECT CONSTNAME ...

The SQL query is a string that contains the ... INFORMATION_SCHEMA database to get information about the primary and foreign keys. For example, the following query returns the table name, the ...

A table can only have one primary key. References the primary key in another table. The values in the foreign key column must match the values in the referenced primary key column or be NULL. The ...

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.

SQL is neither the ... that corresponds to the Persons primary key, and to preserve relational integrity that field should have a foreign key constraint. For example: CREATE TABLE Orders ( OrderID ...