You display the structure of the result set of an SQL statement.
The names of all columns are displayed. These are separated by semicolons.
You have the server authorization AccessSQL.
sql_info <statement>
Option | Description |
---|---|
<statement> | SQL statement |
OK
<col_name>;<col_name>;...;<col_name>
Value | Description |
---|---|
<col_name> | Name of column |
In the event of errors, see Reply Format.
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
Concepts of the Database System, SQL