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.