Hello Matteo,

I had a similar problem and found most of the answers in an article:
http://www.felix-colibri.com/papers/db/interbase/using_interbase_system_tables/using_interbase_system_tables.html

Also "The Firebird Book" by Helen Borrie has an appendix describing the
system tables.

Best regards,

Jan

Am 27.04.2012 09:49, schrieb Matteo Pasqualini:

>
> hi i’m an IT student and i’ve got problems about using System Tables
> to get information abiut my database. i’ve got some questions and i
> can’t find any answer.
> my questions are :
>
> - how can i get the field type of a specific field in the table?
> for example if i create a table with a field named “test” and type
> “Decimal (10,5)” how can i get “Decimal (10,5)” using System Tables?
>
> - how can i get the domain name that i create?
> for example if i create a domain named “YES_NO” how can i get “YES_NO”
> with System Tables?
>
> thanks in advance
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]