I have a table with (col1,col2) as a composite primary key. create table twokeytable(col1 int,col2 int,constraint twokeytable_pk primary key (col1,col2));

and another table with col3,col4 collumns witha composite foreign key(col3,col4) which references the(col1,col2) primary key.

For some processing I need to drop the foreign key and primary constraints .While restoring the constraints does order of the keys matter?.

are these same?

create table fktwokeytable(col3 int,col4 int,constraint fkaddfaa_fk foreign key(col4,col3) references twokeytable(col1,col2))

and

create table fktwokeytable(col3 int,col4 int,constraint fkaddfaa_fk foreign key(col3,col4) references twokeytable(col1,col2))