Firebird SQL statement for table definition

Question

I am writing my own Firebird database browser using the ibpp library. Is there a way to get a table definition using an SQL statement?

Answer 1

Firebird does not support schemas, so you cannot get this information.

The closest owner may be, which you can obtain by requesting RDB$RELATIONS

Edit

A “schema” is a namespace inside a database. You are apparently looking for a table definition, not a schema.

You can get table columns and their data types by querying RDB $ FIELDS and RDB $ RELATION_FIELDS:

 select rf.rdb$relation_name as table_name, rf.rdb$field_name as column_name, case f.rdb$field_type when 14 then 'CHAR' when 37 then 'VARCHAR' when 8 then 'INTEGER' ... end as data_type, f.rdb$field_length, f.rdb$field_scale from rdb$fields f join rdb$relation_fields rf on rf.rdb$field_source = f.rdb$field_name where rf.rdb$relation_name = 'FOOBAR' 

The data type is stored as an integer in the RDB $ FIELD column. A complete list of values ​​in this column is described in the Interbase reference manual: http://www.ibphoenix.com/files/60LangRef.zip (like all other columns in this system table and all other system tables). You may have to go through all the upgrade guides to check if there have been any changes to the system tables since IB 6.0 ("Firebird manualy" is a "mess")