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 | 

Overview

You can easily get various schema information from the SQL statement by using the system catalog virtual class. For example, you can get the following schema information by using the catalog virtual class.

-- Classes that refer to the 'b_user' class

SELECT class_name

FROM db_attribute

WHERE domain_class_name = 'db_user';

 

-- The number of classes that the current user can access

SELECT COUNT(*)

FROM db_class;

 

-- Attribute of the 'db_user' class

SELECT attr_name, data_type

FROM db_attribute

WHERE class_name = 'db_user';