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';

 

=== <Result of SELECT Command in Line 1> ===

 

There are no results.

 

0 rows selected.

 

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

 

=== <Result of SELECT Command in Line 1> ===

 

  class_name   partitioned

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

  'foo'       'NO'          

 

1 rows selected.