Constraints

11 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_order_details_orders

order_details.order_id

orders.order_id

Restrict delete

fk_order_details_products

order_details.product_id

products.product_id

Restrict delete

fk_employees_employees

employees.reports_to

employees.employee_id

Restrict delete

fk_products_categories

products.category_id

categories.category_id

Restrict delete

fk_products_suppliers

products.supplier_id

suppliers.supplier_id

Restrict delete

fk_territories_region

territories.region_id

regions.region_id

Restrict delete

fk_orders_customers

orders.customer_id

customers.customer_id

Restrict delete

fk_orders_employees

orders.employee_id

employees.employee_id

Restrict delete

fk_orders_shippers

orders.ship_via

shippers.shipper_id

Restrict delete

fk_employees_territories_territories

employees_territories.territory_id

territories.territory_id

Restrict delete

fk_employees_territories_employees

employees_territories.employee_id

employees.employee_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint