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