Properties

Primary Table Owner: dbo 
Primary Table: Employees 
Primary Key or Unique Constraint: PK_Employees 
Delete Cascade:  
Update Cascade:  
Description:  

Relationship Columns

Column Reference Column Type
  ReportsTo  EmployeeID  int 
Total: 1 trigger(s)

SQL

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

See Also

Table [dbo.Employees]
Table [dbo.Employees]