Relationship: FK_Products_Suppliers on Products

Collapse All Expand All

Relationship Properties

Name	Value
Not For Replication

FK Columns

	Products Column	Suppliers Column	Type
	SupplierID	SupplierID	int

Extended Properties

SQL

ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Products_Suppliers]
    FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID])
ALTER TABLE [dbo].[Products]
    CHECK CONSTRAINT [FK_Products_Suppliers]

GO

See also

Buildmasters.com.au