Listing the columns of a database table using the OQL Service Provider

Edit online

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

About this task

To issue a database table query using the OQL Service Provider:

Procedure

  1. Start the OQL Service Provider.
  2. Type the following query:
    show table
database_name.table_name;
go
    database_name is the name of the database, and table_name is the name of the required table.