Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM Sysibm.syscolumns WHERE tbname = '[NOMBRE_TABLA]';
- SELECT * FROM Sysibm.syscolumns WHERE tbname = '[NOMBRE_TABLA]' AND FOREIGNKEY='S';
- select substr(R.reftabschema,1,12) as P_Schema, substr(R.reftabname,1,12) as PARENT,
- substr(R.tabschema,1,12) as C_Schema, substr (R.tabname,1,12) as CHILD,
- substr(R.constname,1,12) as CONSTNAME,
- substr(LISTAGG(C.colname,', ') WITHIN GROUP (ORDER BY C.colname),1,20) as FKCOLS
- from syscat.references R, syscat.keycoluse C
- where
- R.constname=C.constname and
- R.tabschema=C.tabschema and
- R.tabname=C.tabname
- group by R.reftabschema, R.reftabname, R.tabschema, R.tabname, R.constname;
Add Comment
Please, Sign In to add comment