Hello all,

First I have to say that I am not an SQL dude, so I need little bit help,
and even more so when dealing with system tables.

I have SQL that fetches field information for the table (written by
someone...):

SELECT RDB$FIELD_SOURCE,RDB$FIELD_POSITION,FIELDS.RDB$FIELD_NAME AS
COLUMN_NAME,RDB$TYPES.RDB$TYPE_NAME AS
DATA_TYPE,RDB$FIELD_POSITION,FIELDS.RDB$NULL_FLAG,RDB$FIELDS.RDB$FIELD_LENGT
H,RDB$FIELDS.RDB$CHARACTER_LENGTH,RDB$FIELDS.RDB$FIELD_PRECISION FROM
RDB$RELATIONS INNER JOIN RDB$RELATION_FIELDS FIELDS ON
RDB$RELATIONS.RDB$RELATION_NAME = FIELDS.RDB$RELATION_NAME LEFT JOIN
RDB$FIELDS ON FIELDS.RDB$FIELD_SOURCE = RDB$FIELDS.RDB$FIELD_NAME LEFT JOIN
RDB$TYPES ON RDB$FIELDS.RDB$FIELD_TYPE = RDB$TYPES.RDB$TYPE WHERE
RDB$RELATIONS.RDB$RELATION_NAME = 'TASKMODIFICATION' AND
RDB$RELATIONS.RDB$SYSTEM_FLAG = 0 AND
RDB$TYPES.RDB$FIELD_NAME='RDB$FIELD_TYPE' ORDER BY FIELDS.RDB$FIELD_POSITION

I would like to get actual Domain "Code" and the fields description given
for the field.

If someone can help me, I would be more than pleased...

-Tommi Prami-