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 | 

Querying on Catalog

To query on catalog classes, you must convert identifiers such as class, virtual class, attribute, trigger, method and index names to lowercases, and create them. Therefore, you must use lowercases when querying on catalog classes.

CREATE TABLE Foo(name varchar(255));

SELECT class_name, partitioned FROM db_class WHERE class_name = 'Foo';

 

There are no results.

 

SELECT class_name, partitioned FROM db_class WHERE class_name = 'foo';

  class_name   partitioned

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

  'foo'       'NO'