Cmd Tab is a command-style SQL interface in Data Management (DMS) that lets you write and run SQL statements interactively.
The interface is split into two areas: the upper area displays the executed SQL statements and their results, and the lower area is where you enter new SQL.
Prerequisites
Before you begin, ensure that you have:
A relational database instance (MySQL, Oracle, or SQL Server)
Query permissions on the target database or table — see Permission management
Open Cmd Tab
Log on to the DMS console V5.0.
In the Database instance section of the left-side navigation pane, find the database you want to query.
Double-click the database to open the SQLConsole tab. For details, see Manage a database on the SQLConsole tab.
Right-click a blank area in the table list on the left, or click a table name, and select Cmd Tab.
In the editor at the bottom of the tab, enter a SQL statement and click Execute or press
Ctrl+Enter.
The executed statement and its results appear in the upper area of the tab.
Example: Create a table named test_table01:
CREATE TABLE test_table01 (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
age INT NOT NULL,
PRIMARY KEY (id)
);
More operations
| Operation | Description |
|---|---|
| Clear screen | Clears all commands displayed in the SQL Command area. |
| Use the editor | Default input mode. Use this to enter SQL in the built-in SQL editor. |
| Use Textarea | Switches to a plain text area for entering SQL statements. |
Ctrl+Enter | Keyboard shortcut to execute the current SQL statement. |