Relationship: FK_Orders_Shippers on Orders

Collapse All Expand All

Relationship Properties

Name	Value
Not For Replication

FK Columns

	Orders Column	Shippers Column	Type
	ShipVia	ShipperID	int

Extended Properties

SQL

ALTER TABLE [dbo].[Orders]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Orders_Shippers]
    FOREIGN KEY ([ShipVia]) REFERENCES [dbo].[Shippers] ([ShipperID])
ALTER TABLE [dbo].[Orders]
    CHECK CONSTRAINT [FK_Orders_Shippers]

GO

See also

Buildmasters.com.au