NoRulez
4th November 2008, 10:16
Hey @all,
did anybody know a way to get the primary and foreign keys from a table?
so when I have a table 'A'
id integer primary key
cid integer foreign key (foreign key for table 'B' column 'id')
and table 'B'
id integer primary key
I want to know that in table 'A' a primary key 'id' exists and there is a foreign key 'cid' which is in table 'B' defined.
Regards
did anybody know a way to get the primary and foreign keys from a table?
so when I have a table 'A'
id integer primary key
cid integer foreign key (foreign key for table 'B' column 'id')
and table 'B'
id integer primary key
I want to know that in table 'A' a primary key 'id' exists and there is a foreign key 'cid' which is in table 'B' defined.
Regards