Foreign keys are columns or combinations of columns that reference the primary key or a unique key of another table. They establish a relationship between two tables and ensure that the values in ...

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.

INNER JOIN sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id INNER JOIN sys.columns AS c ON c.object_id = fk.parent_object_id AND c.column_id = fkc.parent_column_id LEFT JOIN ...

Rooms: RoomID (Primary Key) HotelID (Foreign Key) RoomNumber RoomType (e.g., single, double, suite) Price Reservations: ReservationID (Primary Key) UserID (Foreign Key) RoomID (Foreign Key) ...