Name |
Value |
Not For Replication |
|
PurchaseOrderDetail column |
PurchaseOrderHeader column |
Type |
PurchaseOrderID |
PurchaseOrderID |
int |
Name |
Value |
MS_Description |
Foreign key constraint referencing PurchaseOrderHeader.PurchaseOrderID. |
/ -->
ALTER TABLE [Purchasing].[PurchaseOrderDetail]
WITH CHECK
ADD CONSTRAINT [FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID]
FOREIGN KEY ([PurchaseOrderID]) REFERENCES [Purchasing].[PurchaseOrderHeader] ([PurchaseOrderID])
ALTER TABLE [Purchasing].[PurchaseOrderDetail]
CHECK CONSTRAINT [FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing PurchaseOrderHeader.PurchaseOrderID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderDetail', 'CONSTRAINT', N'FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID'
GO
|