| Subject | Extracting Metadata? | 
|---|---|
| Author | Mustafa Şimşek | 
| Post date | 2005-06-06T09:39:07Z | 
Hi, 
i want to extract metadata from system tables? Anyone has sql scripts
or link for this?
Table, fields, trigger, exceptions, stored proc etc. i coudn't find
something, for example
i extract SP like this but i couldn't extarct CREATE definition?
SELECT rdb$procedure_source
FROM rdb$procedures
WHERE rdb$procedure_name = 'SP_TEST'
Best Regards.
            i want to extract metadata from system tables? Anyone has sql scripts
or link for this?
Table, fields, trigger, exceptions, stored proc etc. i coudn't find
something, for example
i extract SP like this but i couldn't extarct CREATE definition?
SELECT rdb$procedure_source
FROM rdb$procedures
WHERE rdb$procedure_name = 'SP_TEST'
Best Regards.