Overview of All SQLCLI Commands

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