Name |
Value |
Not For Replication |
|
SalesOrderHeader column |
SalesTerritory column |
Type |
TerritoryID |
TerritoryID |
int |
Name |
Value |
MS_Description |
Foreign key constraint referencing SalesTerritory.TerritoryID. |
/ -->
ALTER TABLE [Sales].[SalesOrderHeader]
WITH CHECK
ADD CONSTRAINT [FK_SalesOrderHeader_SalesTerritory_TerritoryID]
FOREIGN KEY ([TerritoryID]) REFERENCES [Sales].[SalesTerritory] ([TerritoryID])
ALTER TABLE [Sales].[SalesOrderHeader]
CHECK CONSTRAINT [FK_SalesOrderHeader_SalesTerritory_TerritoryID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesTerritory.TerritoryID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeader', 'CONSTRAINT', N'FK_SalesOrderHeader_SalesTerritory_TerritoryID'
GO
|