Have a look at RDB$RELATION_CONSTRAINTS



With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> I have two table
>
> table1
> ======
> tbl1_id [primary key]
> tbl1_f1
>
> table2
> =======
> tbl2_id [primary key]
> tbl2_tbl1_id [foreign key reference to tbl1_id]
> tbl2_f2
>
> i retieve metadata using
> SQL :select * from RDB$RELATION_FIELDS where RDB$FIELD_NAME NOT
> LIKE 'RDB$%'
>
> data will be shown will be sth like