Constraints

7 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
Order Details.OrderID
Order Details.ProductID
Orders.OrderID
Products.ProductID
Restrict delete
Territories.RegionID
Regions.RegionID
Restrict delete
Employees.ReportsTo
Employees.EmployeeID
Restrict delete
Products.ProductID
Products.SupplierID
Categories.CategoryID
Suppliers.SupplierID
Restrict delete
CustomerCustomerDemo.CustomerTypeID
CustomerCustomerDemo.CustomerID
CustomerDemographics.CustomerTypeID
Customers.CustomerID
Restrict delete
Orders.CustomerID
Orders.EmployeeID
Orders.ShipVia
Customers.CustomerID
Employees.EmployeeID
Shippers.ShipperID
Restrict delete
EmployeeTerritories.EmployeeID
EmployeeTerritories.TerritoryID
Employees.EmployeeID
Territories.TerritoryID
Restrict delete

Check Constraints

Table Constraint Name Constraint