| Name |
Value |
| Not For Replication |
|
| Product column |
UnitMeasure column |
Type |
| WeightUnitMeasureCode |
UnitMeasureCode |
nchar |
| Name |
Value |
| MS_Description |
Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
/ -->
ALTER TABLE [Production].[Product]
WITH CHECK
ADD CONSTRAINT [FK_Product_UnitMeasure_WeightUnitMeasureCode]
FOREIGN KEY ([WeightUnitMeasureCode]) REFERENCES [Production].[UnitMeasure] ([UnitMeasureCode])
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [FK_Product_UnitMeasure_WeightUnitMeasureCode]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing UnitMeasure.UnitMeasureCode.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'FK_Product_UnitMeasure_WeightUnitMeasureCode'
GO
|