I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta)...