Relationship:
ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
on
SalesOrderDetail_ondisk
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| SalesOrderDetail_ondisk column | SalesOrderHeader_ondisk column | Type |
| SalesOrderID | SalesOrderID | int |
SQL
ALTER TABLE [Sales].[SalesOrderDetail_ondisk] WITH CHECK ADD CONSTRAINT [ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] FOREIGN KEY ([SalesOrderID]) REFERENCES [Sales].[SalesOrderHeader_ondisk] ([SalesOrderID]) ALTER TABLE [Sales].[SalesOrderDetail_ondisk] CHECK CONSTRAINT [ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] GO |
See also