Chau Chee Yang wrote:

> Hi,
>
> I able to use to isql to extract a database metadata. However, I wish to extract only a single table's metadata (create table, index, primary key, triggers) using Firebird API. Is that possible to do so?
>
> Thank you very much.
>
>

All the metadata information are stored on system tables

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.

see you !

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