SQLCLI is a command line database tool for SAP MaxDB. You can use it for accessing data and the database catalog, executing SQL queries, and for creating and managing database objects and database users.
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 |
\dbm <dbm_command> |
Executes the DBM command. See Database Manager CLI, Overview of All DBM Commands |
\dc [PATTERN] |
Lists all table columns that correspond to the PATTERN SQLCLI lists only those tables to which the current user has access. |
\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 |
SQLCLI documentation
Concepts of the Database System, Database Tools