Background documentationSQLCLI Locate this document in the navigation structure

 

SAP MaxDB SQLCLI is a command line database tool for accessing data and the database catalog, executing SQL queries, and for creating and managing database objects and database users.

Overview of all SQLCLI Commands

Command

Description

\! <shell_command>

Executes a shell command

More information: Executing a Shell Command

\?

\h[elp]

Displays all SQLCLI commands

\a[utocommit] [ON|OFF]

Switches AUTOCOMMIT mode on or off

\al[ign] [ON|OFF]

Switches formatted output of the results of SQL statements on or off

\c[onnect]

Logs a user onto the database

More information: Logging On to a Database

\dc [PATTERN]

Lists all table columns that correspond to the PATTERN

SQLCLI lists only those tables to which the current user has access.

See Requesting Information About Database Objects

\de [PATTERN]

Lists all the indexes of database objects that correspond to the PATTERN

\di[sconnect]

Logs the user off from the database

\dp [PATTERN]

Lists all database procedures that correspond to the PATTERN

\ds [NAME]

Lists all schemas that correspond to the NAME pattern

\dt [PATTERN]

Lists all tables that correspond to the PATTERN

\du [NAME]

Lists all database users that correspond to the NAME pattern

\dv [PATTERN]

Lists all views that correspond to the PATTERN

\e[dit][<file>]

Writes the command buffer to the <file> where you can edit it with an editor

More information: Command Buffer

\f[ieldsep] <separator>

Uses the <separator> character to separate the individual fields of the result

\g

Executes the commands in the command buffer and returns the results

\i[nput] <file>

Imports commands from the batch file <file>

More information: Batch File

\m[ode] <INTERNAL|ORACLE>

Changes the SQL mode

\mu[ltiline] ON | OFF

Switches multiple line mode on | off

More information: Multiple Line Mode

\o[utput] <file>

Redirects the result to a file

More information: Redirecting Results to a File

\pa[ger]

Displays results consecutively (not page by page)

\p[rint]

Displays the current command buffer

\q[uit]

Exits SQLCLI

\r[eset]

Deletes the current command buffer

\ro[wsep] <separator>

Uses the <separator> character to separate the individual rows of the result

\s[tatus]

Displays general information about the database

More Information

SQLCLI documentation

Concepts of the Database System, Database Tools