Listing the columns of a database table using the Management Database Access page

You can display a list of the columns of a database table using the show table command.

1. Click the Administration icon and select Network > Management Database Access.
2. Specify a value for the following fields.

   Domain

   Select the domain in which to issue the OQL query.

   Service

   Select the service that you want to query.

3. Click Advanced OQL Query . In the OQL Command field, type the following query:

   show table
   database_name.table_name;
   

   database_name is the name of the database, and table_name is the name of the required table.