var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table Relationships?
which catalog table should I query to find the parent child relationship of a table?
The syscat.references gives very few rows for my database. Shows just 6 relationships. I have many more constarnts/parent-child relationships in the database.
Is there any command that will update the syscat.references table to reflect corrent relationship information.
SYSCAT.REFERENCES is automatically filled in whenever a FOREIGN KEY is defined. e.g. ALTER TABLE mytable add CONSTRAINT myFK FOREIGN KEY (col1) references mytable1 (col2) ON DELETE NO ACTION ON UPDATE NO ACTION
What are you selecting to get your result set.
I am running select * from syscat.references and its returning only 6 rows.
Have you explicitly defined the foreign keys either in the CREATE TABLE
statements or ALTER TABLE statements?