1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| select NULL as TABLE_CAT,
NULL as TABLE_SCHEM,
rel.RDB$RELATION_NAME as TABLE_NAME,
col.RDB$FIELD_NAME as COLUMN_NAME,
fld.RDB$FIELD_TYPE as DATA_TYPE,
'LONG VARBINARY SUB_TYPE TEXT' as TYPE_NAME,
0 as COLUMN_SIZE,
fld.RDB$FIELD_LENGTH as BUFFER_LENGTH,
-(fld.RDB$FIELD_SCALE) as DECIMAL_DIGITS,
0 as NUM_PREC_RADIX,
col.RDB$NULL_FLAG as NULLABLE,
NULL as REMARKS,
fld.RDB$FIELD_PRECISION,
fld.RDB$FIELD_SUB_TYPE
FROM RDB$RELATIONS rel, RDB$RELATION_FIELDS col, RDB$FIELDS fld
WHERE rel.RDB$RELATION_NAME=col.RDB$RELATION_NAME
AND col.RDB$FIELD_SOURCE=fld.RDB$FIELD_NAME
AND rel.RDB$OWNER_NAME='***SchemaName***'
AND rel.RDB$RELATION_NAME='***TableName***' |
Partager