does the order a composite key is defined matter?
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))