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
|