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
>name.
>
>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>.

./hb