ALTER TABLE [Sales].[SalesTaxRate]
WITH CHECK
ADD CONSTRAINT [FK_SalesTaxRate_StateProvince_StateProvinceID]
FOREIGN KEY ([StateProvinceID]) REFERENCES [Person].[StateProvince] ([StateProvinceID])
ALTER TABLE [Sales].[SalesTaxRate]
CHECK CONSTRAINT [FK_SalesTaxRate_StateProvince_StateProvinceID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing StateProvince.StateProvinceID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesTaxRate', 'CONSTRAINT', N'FK_SalesTaxRate_StateProvince_StateProvinceID'
GO
|