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 | 

_db_data_type

Represents the data type supported by CUBRID (see the "Data Types Supported by CUBRID" table in _db_attribute).

Attribute Name

Data Type

Description

type_id

INTEGER

Data type identifier. Corresponds to the "Value" column in the "Data Types Supported by CUBRID" table.

type_name

VARCHAR(9)

Data type name. Corresponds to the "Meaning" column in the "Data Types Supported by CUBRID" table.

Example

The following example shows how to retrieve attributes and type names of the event class.

SELECT a.attr_name, t.type_name

FROM _db_attribute a join _db_data_type t ON a.data_type = t.type_id

WHERE class_of.class_name = 'event'

ORDER BY a.def_order;

  attr_name             type_name

============================================

  'code'                'INTEGER'

  'sports'              'STRING'

  'name'                'STRING'

  'gender'              'CHAR'

  'players'             'INTEGER'