Chau Chee Yang wrote:

>> Take a look on RDB$Relations, RDB$Relation_Fields for a quick overview
>> how it lookslike
>>
>> I don't know your exactly needs, but there are a lot of tools that could
>> do it for you, take a look on FlameRobin for example.
>>
>
> Thank you for your information. I wish to extract the metadata as SQL statements. For example: Create table, create index, Create Table, ...
>

There is no "API function" that return that to you.

> After extracting, I will run these SQL statements. If I traverse those system tables, I need to do quite a lot of coding.

Yep, that's why I suggested one of the available tools, all the work is
already done.

> I am just wondering if there are any quick and easy ways to get the m metadata SQL statements at runtime without any helps of isql tools.
>

Perhaps if you explain better your needs someone could suggest a better
solution.

But as a simple answer to your question, there is no API function to
extract DDL statements from your database.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br