CREATE TABLE [dbo].[Dealer_Supplier]
(
[SupplierID] [int] NOT NULL,
[DealerID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Dealer_Supplier] ADD CONSTRAINT [PK_Dealer_Supplier_SupplierID_DealerID] PRIMARY KEY CLUSTERED ([SupplierID], [DealerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Dealer_Supplier] ADD CONSTRAINT [FK_Dealer_Supplier_DealerID_Account_AccountID] FOREIGN KEY ([DealerID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Dealer_Supplier] ADD CONSTRAINT [FK_Dealer_Supplier_SupplierID_Supplier_SupplierID] FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Supplier] ([SupplierID])
GO