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