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