This topic describes how to query and change a schema by using an SQL statement or
the graphical user interface (GUI) on the SQL Console page.
Prerequisites
You have the permissions to query, modify, and export data in a database. For more
information, see
Manage permissions.
Usage notes
Schema changes may affect relevant databases and business. Proceed with caution when
you change a schema.
Query a schema
- Go to the SQL Console page.
- In the navigation tree on the left of the SQL editor, right-click the target table
and select Object Information.
- In the Basic information dialog box, click the Create statement tab. The SQL statement that was used to create the table appears.
Note You can also enter a
desc clause in the SQL editor to query the schema of the table.

Change a schema by using the GUI
This section uses an example of adding a column to describe how to change a schema
by using the GUI. You can also perform other changes on a schema, such as adding an
index to a foreign key or modifying the storage engine.
- Go to the SQL Console page.
- In the navigation tree on the left of the SQL editor, right-click the target table
and select Edit Table Structure.
- On the Change Table tab, click Column Info on the left.
- Click New.
- A new row appears. Enter relevant information in the new row and click Modify in the lower part of the tab.
- In the Modify dialog box, click Execute.
Change a schema by using an SQL statement
- Go to the SQL Console page.
- On the SQLConsole tab, enter an SQL statement for changing the schema of the target table in the SQL
editor and click Execute.