> -----Original Message-----
> can any one please tell me how to retrun the description of
> table or colummn by using the SQL statement?
> Is that passible to do in the Firebird? Or I can only using
> the join state to select the related data from system table ?
> By the way, how to change the description?

See this link for table info (http://www.fbtalk.net/viewtopic.php?id=4) and
this link for column information (http://www.fbtalk.net/viewtopic.php?id=16)

Updating descriptions is done via standard sql, something like:

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = 'some description or other'
WHERE RDB$RELATION_NAME = 'EMPLOYEE';

Hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage