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]
