Relationship: FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID on SalesOrderHeaderSalesReason

CollapseAll image

Collapse image Relationship properties


 Name   Value 
 Not For Replication   
 On Delete   CASCADE 

Collapse image FK columns


SalesOrderHeaderSalesReason column SalesOrderHeader column Type
SalesOrderID SalesOrderID int

Collapse image Extended properties


Name  Value 
MS_Description Foreign key constraint referencing SalesOrderHeader.SalesOrderID.
/ -->

Collapse image SQL


ALTER TABLE [Sales].[SalesOrderHeaderSalesReason]
    WITH CHECK
    ADD CONSTRAINT [FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID]
    FOREIGN KEY ([SalesOrderID]) REFERENCES [Sales].[SalesOrderHeader] ([SalesOrderID])
    ON DELETE CASCADE
ALTER TABLE [Sales].[SalesOrderHeaderSalesReason]
    CHECK CONSTRAINT [FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesOrderHeader.SalesOrderID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesOrderHeaderSalesReason', 'CONSTRAINT', N'FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID'
GO

Collapse image See also


[Sales].[SalesOrderHeaderSalesReason]

[Sales].[SalesOrderHeader]