Information about columns with SQL

I'd like to get a list for some of my db-tables by a simple ;-) SQL-Statement: This list should contain information like: tablename, columname, rights (what does the "su-idxar"-flags in systabauth really mean: select, update, ?!?, indexing, delete, exclusive lock, alter table, ?!?) data type (integer, varchar, year-to-fraction etc.) index on column. Especially with the data type I'm having problems getting information about it. I'm running IDS 7.30 UC6. Any useful help will greatly be appreciated thomas ------------------------------------------------- Thomas Stainer - thomas.stainer@open-it.at