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
|