Primary Table Owner: | Sales |
Primary Table: | SalesPerson |
Primary Key or Unique Constraint: | PK_SalesPerson_SalesPersonID |
Delete Cascade: | |
Update Cascade: | |
Description: | Foreign key constraint referencing SalesPerson.SalesPersonID. |
Column | Reference Column | Type | |
SalesPersonID | SalesPersonID | int |
ALTER TABLE [Sales].[SalesOrderHeader] ADD CONSTRAINT [FK_SalesOrderHeader_SalesPerson_SalesPersonID] FOREIGN KEY
(
[SalesPersonID]
) REFERENCES [SalesPerson] (
[SalesPersonID]
)
GO
See Also
Table [Sales.SalesPerson]