retrieve column names from a table

admin

Administrator
Staff member
Hi,
Does anyone knows how to get info about the columns of a table?
I need to know all column names of given table in order to compose a form.
I know that I can get this kind info if I perform this query, select * from mytable, and perform a ibase_field_info but if the table is empty I can\\\'t do this way. Also, I just want the columns names not the values.
it should be a sql query that works like the isql command show table mytable.
I\\\'m working with interbase6

Thanks.
 
Back
Top