At 03:45 PM 19-08-01 +0200, you wrote:

>Is there SQL command which shows definition for some table in database ?

The system tables are just tables in your database - query them as any other IB table.

There is a whole section in the LangRef on the system tables.

Or, if you want to do it the easy way, and you have a Windows client, get IB_SQL.exe (free) from http://www.ibobjects.com

The Browser shows you all you ever wanted to know about your metadata (and even some things you didn't know, maybe!)

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________