Subject | Re: [firebird-support] Find primary- and foreignkey-fields from metadata |
---|---|
Author | Martijn Tonies |
Post date | 2004-03-29T13:41:11Z |
Hi Josef,
in combination with RDB$INDICES.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Could anybody help me with a query-statement to find out primary- andLook at RDB$RELATION_CONSTRAINTS and RDB$REF_CONSTRAINTS
> foreign-key fields of a Firebird database.
in combination with RDB$INDICES.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com