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.
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. |
\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 |