| command | note | status | comment |
|---|
| !all | Execute the specified SQL against all the current connections. |  | --- |
| !autocommit | Enable or disable automatic transaction commit mode |  | Impossible to disable autocommit |
| !batch | Start or execute a batch of SQL statements | | --- |
| !brief | Enable terse output mode | | --- |
| !verbose | Enable verbose output mode | | --- |
| !call | Execute a callable statement |  | Doesn't support from our side. |
| !close | Close the active connection | | Error message: Ambiguous command: [close, closeall] |
| !closeall | Close all current open connections | | --- |
| !columns | Display columns of a table | | Display int instead of type of field e.g. -5 = java.lang.Long, 12 = java.lang.String |
| !commit | Commit the current transaction, if autocommit is off. | | autocommit always true so commit doesn't make sense |
| !connect | Connect to a database | | --- |
| !dbinfo | List metadata information about the current connection. | | --- |
| !describe | Synonym for columns (if an argument is specified) or tables (if no argument is specified).
| | Doesn't work without parameter. so now !describe =!columns |
| !dropall | Drop all tables in the database | | --- |
| !exportedkeys | List exported foreign keys for a database | | Doesn't support from our side. |
| !go | Change to a different active connection | | --- |
| !help | Display help information | | Help shows not all commands that there are in manual. |
| !history | Display the command history | | --- |
| !importedkeys | List imported foreign keys for a database | | Doesn't support from our side. |
| !indexes | Display indexes for a table | | --- |
| !isolation | Set the transaction isolation mode for the active connection | | autocommit always equals true so I can't to test this parameter |
| !list | Display all active connections | | --- |
| !manual | Display sqlline manual | | --- |
| !metadata | Invoke arbitrary metadata commands | | --- |
| !nickname | Create a friendly name for the connection (updates command prompt) | | --- |
| !outputformat | Change the method for displaying SQL results | | --- |
| !primarykeys | Display the primary key columns for a table | | --- |
| !procedures | List stored procedures | | Doesn't support from our side. |
| !properties | Connect to the database defined in the specified properties file. | | --- |
| !quit | Exit SQLLine | | --- |
| !reconnect | Reconnect to the current database | | --- |
| !record | Begin recording all output from SQL commands | | --- |
| !rehash | Get a list of all tables and columns from the database in order to include them in the list for tab-completion of SQL statements. This is done automatically on connect when the fastconnect option is enabled. | - with and without fastconnect | NPE from sqlline side |
| !rollback | Roll back the current transaction (if autocommit is off) | | autocommit always true so rollback doesn't make sense |
| !run | Execute a command script | | --- |
| !save | Save the current preferences to some file | | Doesn't override current parameters in ~/.sqlline/sqlline.properties |
| !scan | Scan class path for JDBC drivers | | Output - Compliant Compliant Version Compliant Compliant Version Driver Class Compliant Compliant Version Compliant Compliant Version Driver Classno 1.0 org.apache.ignite.IgniteJdbcDriverCompliant Compliant Version Compliant Compliant Version Driver Classno |
| !script | Save executed commands to a file | | --- |
| !set | Set a sqlline variable | | Values of parameters wasn't changed |
| !sql | Execute a SQL against a database | | --- |
| !tables | List all the tables in the database | | --- |