Relationship:
FK_WorkOrder_Product_ProductID
on
WorkOrder
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| WorkOrder column | Product column | Type |
| ProductID | ProductID | int |
Extended properties
| Name | Value |
| MS_Description | Foreign key constraint referencing Product.ProductID. |
SQL
ALTER TABLE [Production].[WorkOrder] WITH CHECK ADD CONSTRAINT [FK_WorkOrder_Product_ProductID] FOREIGN KEY ([ProductID]) REFERENCES [Production].[Product] ([ProductID]) ALTER TABLE [Production].[WorkOrder] CHECK CONSTRAINT [FK_WorkOrder_Product_ProductID] GO EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Product.ProductID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrder', 'CONSTRAINT', N'FK_WorkOrder_Product_ProductID' GO |
See also