Subject | How to get the type of a column? |
---|---|
Author | W O |
Post date | 2011-04-02T00:21:39Z |
Hello everybody
With the following sentence:
SELECT R.RDB$FIELD_NAME, F.RDB$FIELD_TYPE FROM RDB$RELATION_FIELDS R JOIN
RDB$FIELDS F ON RDB$FIELD_SOURCE = F.RDB$FIELD_NAME WHERE RDB$RELATION_NAME
= 'CLIENTS'
I can get the name and the numeric type of the columns, but I had not found
as to get the name of the type (char, varchar, smallint, etc.)
How I can to get the type's names?
Thank in advance.
Walter.
[Non-text portions of this message have been removed]
With the following sentence:
SELECT R.RDB$FIELD_NAME, F.RDB$FIELD_TYPE FROM RDB$RELATION_FIELDS R JOIN
RDB$FIELDS F ON RDB$FIELD_SOURCE = F.RDB$FIELD_NAME WHERE RDB$RELATION_NAME
= 'CLIENTS'
I can get the name and the numeric type of the columns, but I had not found
as to get the name of the type (char, varchar, smallint, etc.)
How I can to get the type's names?
Thank in advance.
Walter.
[Non-text portions of this message have been removed]