The following table shows all the SQLCLI commands that you can enter in interactive operation.
Instead of an SQLCLI command, you can also enter an SQL statement or a database procedure. For an introduction to the SQL statements available, see the SQL Tutorial. For a detailed overview of the syntax and semantics of SQL statements, see the SQL Reference Manual.
Command |
Description |
\! <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] |
|
\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 the database instance |
\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 <file>, where you can edit it with an editor |
\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> |
\m[ode] <INTERNAL|ORACLE|ANSI|DB2> |
Changes the SQL mode |
\mu[ltiline] ON | OFF |
Activates / deactivates multiple row mode |
\o[utput] <file> |
|
\pa[ger] |
Results are displayed successively (not page by page) |
\p[rint] |
Displays the current command buffer |
\q[uit] |
Ends 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 instance |