Relationship:
FK_SalesTaxRate_StateProvince_StateProvinceID
on
SalesTaxRate
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| SalesTaxRate column | StateProvince column | Type |
| StateProvinceID | StateProvinceID | int |
Extended properties
| Name | Value |
| MS_Description | Foreign key constraint referencing StateProvince.StateProvinceID. |
SQL
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 |
See also