The following two requests return attribute information for all the columns of the named table or view. All column attributes are returned, except any default values and comments (for these, use HELP TABLE table_name ).
HELP COLUMN * FROM table_name; HELP COLUMN table_name.*;