Relationship: FK_Employees_Employees on Employees

Collapse All Expand All

Relationship Properties

Name	Value
Not For Replication

FK Columns

	Employees Column	Employees Column	Type
	ReportsTo	EmployeeID	int

Extended Properties

SQL

ALTER TABLE [dbo].[Employees]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Employees_Employees]
    FOREIGN KEY ([ReportsTo]) REFERENCES [dbo].[Employees] ([EmployeeID])
ALTER TABLE [dbo].[Employees]
    CHECK CONSTRAINT [FK_Employees_Employees]

GO

See also

Buildmasters.com.au