How do you get a list of the column names in an specific table?
ie.
Firebird table:
| name | id | phone_number |
get list like this:
columnList = ['name', 'id', 'phone_number']
if you want to get a list of column names in an specific table, this is the sql query you need:
select rdb$field_name from rdb$relation_fields
where rdb$relation_name='YOUR-TABLE_NAME';
I tried this in firebird 2.5 and it works.
the single quotes around YOUR-TABLE-NAME are necessary btw