Relationship:
FK_SalesPerson_SalesTerritory_TerritoryID
on
SalesPerson
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| SalesPerson column | SalesTerritory column | Type |
| TerritoryID | TerritoryID | int |
Extended properties
| Name | Value |
| MS_Description | Foreign key constraint referencing SalesTerritory.TerritoryID. |
SQL
ALTER TABLE [Sales].[SalesPerson] WITH CHECK ADD CONSTRAINT [FK_SalesPerson_SalesTerritory_TerritoryID] FOREIGN KEY ([TerritoryID]) REFERENCES [Sales].[SalesTerritory] ([TerritoryID]) ALTER TABLE [Sales].[SalesPerson] CHECK CONSTRAINT [FK_SalesPerson_SalesTerritory_TerritoryID] GO EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesTerritory.TerritoryID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesPerson', 'CONSTRAINT', N'FK_SalesPerson_SalesTerritory_TerritoryID' GO |
See also