CUBRID Query Browser Reference

Create Table

Create Table Options:

• General tab : You can define the name of the table to be added and add, edit and drop columns. You can also set the primary key (PK) and, before the table is created, adjust the position of the selected column by using ↑ and ↓.
  Using the add column wizard, you can set the name, type, default value and constraints of the column to be added. You can also set to display a warning message when you enter something that is not grammatically correct, or to disable the selection of a grammatically incorrect entry.
  • Reuse_OID : If this option is selected, a table is created with the option REUSE_OID applied. For this kind of table, using with OID is restricted. For more information on OID reuse table, see "Table Options (REUSE_OID)" in the CUBRID online manual.
• FK/Indexes tab : You can set foreign keys and indexes.
  • Add Foreign Key : Using the add foreign key wizard, you can set the name of the foreign key, the name and primary key of the reference table and the trigger actions to maintain referential integrity. The ON UPDATE, ON DELETE and ON CACHE OBJECT options are provided.
  • Add Index : You can set index name, index type, a column to be indexed. Ascending (asc) and descending (desc) sorting can be selected within the supported range. For REVERSE indexes, only descending sorting is supported.
• Partition Tab : Supports partitioning setting and modification of the given table.
  • Add Partition : Using the add partition wizard, you can set the partition type and expression. The RANGE, LIST and HASH partitions are supported.
  • Edit/Delete Partition : You can edit or delete partition.
• SQL Statement Tab : You can check and copy SQL statements created according to the settings in General, Foreign Key/Index and Partition tabs.

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.

• General tab : When you select Show object oriented related properties, Shared, Inheritance and Table column are added as a column in the table. When adding or editing columns, you can choose the column type as shown in the figure below. You can choose OBJECT or a table in the database as the data type.
• Inheritance tab : You can define the super table to inherit from. If a column name conflict occurs, it can be adjusted.

Create Table Like

Creates an empty table which has the same schema structure with an existing one. It works the same as CREATE TABLE LIKE.

Create View

Specify the view name and the owner, click the Add button, and then enter the query for the view to be created. You can check the contents entered in the Create View wizard from the SQL statement in the SQL Script tab.

Execute Defined SQL

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.

Export Data

Data (one or more tables) can be exported in Excel (.xls), CSV, SQL, or CUBRID load (.obs) format. The export progress will create a new file for each table and save the files into the path which you specified in File path. File charset is used to specify the file charset of the exported data.

Import Data

You can import data from an Excel or CSV file into the database.

• JDBC charset : Used to specify the charset when getting data from a file, and use JDBC charset to specify charset of the data to be imported into the database. The JDBC charset only can be changed at the Open Connection dialog, and the new value will work after the database is reconnected.
• File charset : Used to specify the charset of data to be imported from a file.
• Thread count : The import process support multi-thread to make better performance. It is used to specify how many thread will run during the importing, 5 is recommended and do not make it larger than 10.
• Commit lines once : Used to specify how many rows that memory cache stored in one thread, if the memory cache is full, all data in the cache will be committed to the database and new data will start to fill the memory cache.
• Mapping between file columns and table columns
• • If the first row of the import data is the names of columns, the Use the first line data as column names should be checked.
  • The buttons Delete(of file column), Up, Down, Delete (of Table column) are used to specify the correspondence between file columns and table columns.
• Error-Handling : used to specify what the import progress will do when errors occurred. If Ignore is checked, the import progress will ignore all errors and show an error report dialog when progress is finished and errors occurred. And if the Break is checked, the progress will be broke when error occurred, but the committed data will not be rollback.

Trigger

Create Trigger options:

• Trigger name : Enter the name of the trigger to be added.
• Target table/Target column : Enter the target table and column information.
• Event Time : Select the point of time when the condition of the trigger is to be evaluated. You can select from BEFORE, AFTER, and DEFERRED.
• Event Type : Select the type of the event to be occurred. Event types are INSERT, DELETE, UPDATE, STATEMENT INSERT, STATEMENT DELETE, STATEMENT UPDATE, COMMIT and ROLLBACK.
• Event Condition : Enter the condition for the trigger action.
• Execution Time : Specify the point of time when the trigger to be executed. If DEFAULT is selected, the trigger fires based on the point of time when its condition is validated.
• Action Type : Select the type of the trigger action. If the type of the trigger action is PRINT, OTHER, or STATEMENT you can enter addition information in the SQL statement or print messages for action type.
• Trigger Status : You can specify whether to activate or deactivate the trigger to be added.
• Trigger Priority : You can set the priority of the trigger. The priority value is a FLOAT and can be between 0.00 and 9999.99.

TRUNCATE TABLE

You can delete entire records including indexes and constraints in a table by right-clicking More > TRUNCATE TABLE. This way is faster than using DELETE ALL because all indexes and constraints defined in the table are deleted before deleting records. The ON DELETE trigger is not activated when you use the TRUNCATE TABLE.

Preferences

General:

• Show window maximize : The window of the CUBRID Query Browser is maximized when it is opened.
• Always exit without prompt : The confirmation prompt is not shown up when the CUBRID Query Browser is closed.
• Create the new information of CUBRID : The now information of CUBRID is shown up when the CUBRID Query Browser is opened.
• Open mode : Determine single click or double click when a node is opened in the connection explorer.

Import Options:

• Import options is used to specify which value will be turn to NULL when import data to database. Strings "NULL", "(NULL)" and "N" are the default options and you can input some custom values into the text area, the max length of text is 256 characters.

JDBC Management:

• Add : You can select and add the CUBRID JDBC driver file after opening a file selection dialog.
• Delete : You can delete selected CUBRID JDBC driver from the list