Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

CUBRID SQL Guide

CUBRID is an object-relational database management system (ORDBMS), which supports object-oriented concepts such as inheritance. In this manual, relational database terminology is also used along with object-oriented terminology for better understanding. Object-oriented terminology such as class, instance and attribute is used to describe concepts including inheritance, and relational database terminology is mainly used to describe common SQL syntax.

The following table provides the summary:

Relational Database

CUBRID

table

class, table

column

attribute, column

record

instance, record

data type

domain, data type

This chapter describes SQL syntax such as datatypes, functions and operators, data retrieval or table manipulation. You can also find SQL statements used for index, trigger, partition, serial and changing user information.

The main topics covered in this chapter are as follows:

  • Data types
  • Operators and functions
  • Data retrieval
  • Query optimization
  • Table manipulation
  • Data manipulation
  • Virtual tables (VIEW)
  • Indexes (INDEX)
  • Transaction management
  • Triggers (TRIGGER)
  • Methods
  • Partitions
  • Serials
  • Grant access statements
  • Java stored functions/procedures
  • CUBRID SQL statements