Working with Keys

A primary key is a constraint that assures that each table contains no duplicate rows. A foreign key is a constraint that enforces referential integrity. For more information about keys, see Keys.

For details about working with keys, see the following topics.

How to: Create Primary Keys

How to: Modify Primary Keys

How to: Delete Primary Keys

How to: Modify Foreign Key Relationships

How to: Delete Foreign Key Relationships

How to: View Foreign Key Properties

How to: Disable Foreign Key Constraints for Replication

How to: Disable Foreign Key Constraints with INSERT and UPDATE Statements

See Also

Other Resources

Reference (Visual Database Tools)

Working with Relationships

Working with Constraints

Working with Indexes