View table column names and types

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

To view column names and types

1. Optional: 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 the following:

   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: Viewing Column Names and Types

For example, if you execute the following ISQL command, the ISQL tool will list all columns that exist in the MPConnection table and their types:

select column_name, type_name from oa_columns where table_name = 'doas dataset';