Hi,All.
Here is a sql for ASE obtaining a table's foreign key information.But
I dunoo how to translate it in equivalent sql for IQ database.
Thanks.

SQL:
select object_name(sc.constrid) name, object_name(sr.tableid)
referencing_table, user_name(so.uid) referencing_owner,
isnull(sr.frgndbname, db_name()) referencing_database,
rtrim( col_name(sr.tableid, fokey1) + " " + col_name(sr.tableid,
fokey2) + " " + col_name(sr.tableid, fokey3) + " " +
col_name(sr.tableid, fokey4) + " " + col_name(sr.tableid, fokey5) + "
" + col_name(sr.tableid, fokey6) + " " + col_name(sr.tableid, fokey7)
+ " " + col_name(sr.tableid, fokey8) + " " + col_name(sr.tableid,
fokey9) + " " + col_name(sr.tableid, fokey10) + " " +
col_name(sr.tableid, fokey11) + " " + col_name(sr.tableid, fokey12) +
" " + col_name(sr.tableid, fokey13) + " " + col_name(sr.tableid,
fokey14) + " " + col_name(sr.tableid, fokey15) + " " +
col_name(sr.tableid, fokey16)) referencing_columns,
object_name(sr.reftabid, sr.pmrydbid) referenced_table,
user_name(so2.uid) referenced_owner, isnull(sr.pmrydbname, db_name())
referenced_database, rtrim( col_name(sr.reftabid, refkey1,
sr.pmrydbid) + " " + col_name(sr.reftabid, refkey2, sr.pmrydbid) + "
" + col_name(sr.reftabid, refkey3, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey4, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey5, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey6, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey7, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey8, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey9, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey10, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey11, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey12, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey13, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey14, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey15, sr.pmrydbid) + " " +
col_name(sr.reftabid, refkey16, sr.pmrydbid)) referenced_columns,
sr.keycnt number_of_columns from sysconstraints sc, sysreferences sr,
sysobjects so, sysobjects so2 where sc.constrid = sr.constrid and
sr.tableid = so.id and sr.reftabid = so2.id and and
object_name(sc.constrid) = "constraint_name" and
object_name(sr.tableid) = "table_name"