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