View table column names and types

Use the Interactive SQL (ISQL) tool to view the column names and types in a table.

To view table column names and types

1. By default, all ISQL commands return a maximum of 100 results. To disable the maximum number of results, enter maxrows 0, and press Enter.

2. Enter select column_name, type_name from oa_columns where table_name = '<table name>';

   Where <table name> is the table for which you want to see the column names and types.

3. Press Enter.

Example

If you execute the following ISQL command, the ISQL tool will list all columns that exist in the xoslogins table and their types:

select column_name, type_name from oa_columns where table_name = 'xoslogins';