Background documentationsql_info Locate this document in the navigation structure

 

With this command you can 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 permission 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 Database Manager CLI as the operator OLEG with the password MONDAY, connect to the DEMODB database, and display the structure of the result set for the SELECT statement , which is 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