Name |
Value |
Not For Replication |
|
WorkOrder column |
ScrapReason column |
Type |
ScrapReasonID |
ScrapReasonID |
smallint |
Name |
Value |
MS_Description |
Foreign key constraint referencing ScrapReason.ScrapReasonID. |
/ -->
ALTER TABLE [Production].[WorkOrder]
WITH CHECK
ADD CONSTRAINT [FK_WorkOrder_ScrapReason_ScrapReasonID]
FOREIGN KEY ([ScrapReasonID]) REFERENCES [Production].[ScrapReason] ([ScrapReasonID])
ALTER TABLE [Production].[WorkOrder]
CHECK CONSTRAINT [FK_WorkOrder_ScrapReason_ScrapReasonID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ScrapReason.ScrapReasonID.', 'SCHEMA', N'Production', 'TABLE', N'WorkOrder', 'CONSTRAINT', N'FK_WorkOrder_ScrapReason_ScrapReasonID'
GO
|