When you log in to the database, you can see accessible tables and system tables and columns and index in the navigation tree.
If you right-click the [Table] in the navigation tree, you can view the [Create Table], [Create Like Table], and [Refresh] menus.
Right-click [Tables] in the navigation tree and then select [Create Table] or click [Create Table ] from the toolbar. Then, a wizard which makes you create a new table will appear.
Adding Object Oriented Tables
To add a table with object-oriented properties, select [Show object oriented related properties]. When you select [Show object oriented related properties], the Inheritance tab is added.
Right-click a table in the navigation tree and select [Select All]. Or you can drag and drop the table into the editor results pane of the Query editor when it is open. Then, a new Query editor opens and retrieves the entire data.
Retrieves a total data count of the table and performs the same functionality as the following syntax.
SELECT COUNT(*) FROM table_name
Deletes all records from the table and performs the same functionality as the following syntax.
DELETE FROM table_name
Deletes entire data in the table. It can delete all records including indexes and constraints in a table, so it is faster than [DELETE ALL]. The ON DELETE trigger is not activated when you use the [TRUNCATE TABLE]. It can perform the same functionality as the following syntax.
TRUNCATE TABLE table_name
You can insert values for each column while checking its type and constraints.
You can import data from an Excel or CSV file into the database. You can use [File charset] to get data from a file, and use [JDBC charset] to specify charset for data to be stored in the database. To change the value for [JDBC charset], right-click the mouse and then select [Properties].
By selecting [Ignore] or [Break], you can change the way when an error occurs in the process of import.
You can export data (usually in one or more tables) in Excel (.xls), CSV, SQL, or CUBRID load (.obs) format. A file name is created with a table name and it is saved in the path specified in [File path]. You can choose [File charset] when exporting data.
Drops the selected table. This is the same as the DROP TABLE statement.
You can change the name of the current table. It is the same as RENAME TABLE statement.
Creates an empty table which has the same schema structure with an existing one. It works the same as CREATE TABLE LIKE. For details, see "CREATE TABLE LIKE" in the CUBRID online manual.
You can use all functionalities of [Create Table] in [Edit Table] as well. However, you cannot adjust the order of columns in the table.
You can check the schema information of the table by double-clicking it.
With [Execute Defined SQL] menu, you can execute "prepared statement," pre-saving a specific query statement and specifying a new parameter value for the statement whenever the query is executed.
You can execute the SELECT statement which meets specified conditions by entering a parameter value of defined "prepared statement" by using [Select by input value].
You can execute the INSERT statement by entering a parameter value of defined "prepared statement" by using [Insert by input value].
You can use [Select by read file] when repeating the execution of SELECT statement by inputting several parameter values in the defined "prepared statement." The data is saved in Excel (.xls) or CSV format. You can configure a file charset where parameter values are saved, the number of concurrent threads to be executed, and commit cycle. To change the value for [JDBC charset], right-click the mouse in Explorer and then select [Properties].
You can use [Insert by read file] when repeating the execution of INSERT statement by inputting several parameter values in the defined "prepared statement." The data is saved in Excel (.xls) or CSV format. You can configure a file charset where parameter values are saved, the number of concurrent threads to be executed, and commit cycle. To change the value for [JDBC charset], right-click the mouse in Explorer and then select [Properties].
A convenient function is provided that allows you to copy DDL and DML in a selected table to the current editor. If there is no editor opened, a new editor will opened and show the DDL or DML in it. The text in menu item gives the format of the statement. You can modify it based upon your requirements. INSERT, SELECT, CREATE, UPDATE, DELETE and GRANT statements are included.
Like [Copy SQL to Editor], you can copy DDL and DML in a selected table. But the difference is the object address is clipboard.
You can copy DDL and DML in a selected table to a given file.