balogatt wrote:

> Hi All!
>
> How to get all name of fields of the database?
> I try this:
>
> CREATE VIEW TABLE_CONSTRAINTS(
> FIELD_NAME)
> AS
> SELECT RDB$FIELD_NAME
> FROM RDB$RELATION_FIELDS
> ;

Looks about right, what is the problem.
This will give EVERY field in the database, just add a
WHERE RDB$RELATION_NAME = 'table' to filter it
or
WHERE RDB$SYSTEM_FLAG <> 1 to drop the system table entries

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.