Subject Re: [firebird-support] What SQL to use to retrieve all details of a given table
Author Helen Borrie
At 01:29 PM 2/04/2005 +0530, you wrote:

>Hi all
>What kind of a SQL statement can we execute on a database to retrieve all
>details (fields, indices, constraints, triggers, etc.) of the given table
>Is this possible?

One statement? No. Write a parameterised stored procedure that queries
the relevant system tables, targeting rdb$relation_name = 'aTable'.

>Actually I would like to print or atleast view linear-ly
>a given table's complete details for creation of a similar table.

Use isql SHOW TABLE <table-name>.