Properties

Primary Table Owner:	HumanResources
Primary Table:	Employee
Primary Key or Unique Constraint:	PK_Employee_EmployeeID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing Employee.EmployeeID.

Relationship Columns

	Column	Reference Column	Type
	SalesPersonID	EmployeeID	int

Total: 1 trigger(s)

SQL

ALTER TABLE [Sales].[SalesPerson] ADD CONSTRAINT [FK_SalesPerson_Employee_SalesPersonID] FOREIGN KEY
    (
        [SalesPersonID]
    ) REFERENCES [Employee] (
        [EmployeeID]
    )
GO

See Also

Table [HumanResources.Employee]
Table [Sales.SalesPerson]