Show TOC

Background documentationOverview of All SQLCLI Commands Locate this document in the navigation structure

 

The following table shows all SQLCLI commands that you can enter in interactive operation.

Note Note

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.

End of the note.
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