Remove _t_contient
from the script and try.
Create table contient(
Num_Spect varchar(30) not null,
Code_Module varchar(30) not null,
constraints pk_contient primary key (Num_Spect,Code_Module),
constraints fk_spect FOREIGN key (Num_Spect) REFERENCES specialite(Num_Spect),
constraints fk_module FOREIGN key (Code_Module) REFERENCES module(Code_Module));
solved what am I doing wrong with this script [closed]