Subject | Extract metadata |
---|---|
Author | Marcos Vinicius Dufloth |
Post date | 2002-08-30T17:35:27Z |
Hi. I need extract some metadata from database. I need some view, or
procedure that generate rows with field name, field type and size, and,
if possible, if field is primary key. I want extract this information
from data dictionary, but the hardest thing is resolve the field type
and size, like VARCHAR(20) or NUMERIC(8,3). What RDB$ tables I need to
do this?
Can anybody help me with this?
TIA,
Dufloth.
procedure that generate rows with field name, field type and size, and,
if possible, if field is primary key. I want extract this information
from data dictionary, but the hardest thing is resolve the field type
and size, like VARCHAR(20) or NUMERIC(8,3). What RDB$ tables I need to
do this?
Can anybody help me with this?
TIA,
Dufloth.