CREATE TABLE [dbo].[ActionEduThematiques] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Nom] NVARCHAR (MAX) NOT NULL, [Neutralise] BIT NOT NULL, [Ordre] INT NOT NULL, [ActionEduAxeId] INT NOT NULL, CONSTRAINT [PK_ActionEduThematiques] PRIMARY KEY CLUSTERED ([Id] ASC), CONSTRAINT [FK_ActionEduAxeActionEduThematique] FOREIGN KEY ([ActionEduAxeId]) REFERENCES [dbo].[ActionEduAxes] ([Id]) ); GO CREATE NONCLUSTERED INDEX [IX_FK_ActionEduAxeActionEduThematique] ON [dbo].[ActionEduThematiques]([ActionEduAxeId] ASC);