Background documentationsql_info Locate this document in the navigation structure

 

You display the structure of the result set of an SQL statement.

The names of all columns are displayed. These are separated by semicolons.

Prerequisites

You have the server authorization AccessSQL.

Structure

sql_info <statement>

Options

Option

Description

<statement>

SQL statement

Result

OK

<col_name>;<col_name>;...;<col_name>

Values for the Reply Fields

Value

Description

<col_name>

Name of column

In the event of errors, see Reply Format.

Example

Log on to the Database Manager CLI as operator OLEG with password MONDAY, connect to the DEMODB database instance, display the structure of the result set for the SELECT statement used to display the content of the USERS table:

>dbmcli -u OLEG,MONDAY -d DEMODB sql_info SELECT * FROM users

OK

OWNER;GROUPNAME;USERNAME;USERMODE;CONNECTMODE;MAXTIMEOUT;COSTWARNING; COSTLIMIT;DEFAULTCODE;CREATEDATE;CREATETIME;ALTERDATE;ALTERTIME;PWCREADATE;PWCREATIME;SERVERDB;SERVERNODE;USER_ID;ISREPLICATIONUSER;COMMENT

More Information

Concepts of the Database System, SQL