Tables [dbo].[Dealer_Supplier]
PropertyValue
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_Dealer_Supplier_SupplierID_DealerID: SupplierID\DealerIDForeign Keys FK_Dealer_Supplier_SupplierID_Supplier_SupplierID: [dbo].[Supplier].SupplierIDSupplierIDint4
False
Cluster Primary Key PK_Dealer_Supplier_SupplierID_DealerID: SupplierID\DealerIDForeign Keys FK_Dealer_Supplier_DealerID_Account_AccountID: [dbo].[Account].DealerIDDealerIDint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Dealer_Supplier_SupplierID_DealerID: SupplierID\DealerIDPK_Dealer_Supplier_SupplierID_DealerIDSupplierID, DealerID
True
NameDeleteColumns
FK_Dealer_Supplier_DealerID_Account_AccountIDCascadeDealerID->[dbo].[Account].[AccountID]
FK_Dealer_Supplier_SupplierID_Supplier_SupplierIDSupplierID->[dbo].[Supplier].[SupplierID]
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