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