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_index

Represents index information. An index for class_of is created.

Attribute Name

Data Type

Description

class_of

_db_class

Class to which to index belongs

index_name

varchar(255)

Index name

is_unique

INTEGER

1 if the index is unique, and 0 otherwise.

key_count

INTEGER

The number of attributes that comprise the key

key_attrs

SEQUENCE OF _db_index_key

Attributes that comprise the key

is_reverse

INTEGER

1 for a reverse index, and 0 otherwise.

is_primary_key

INTEGER

1 for a primary key, and 0 otherwise.

is_foreign_key

INTEGER

1 for a foreign key, and 0 otherwise.

filter_expression

VARCHAR(255)

The conditions of filtered indexes

have_function

INTEGER

1 for a foreign key, and 0 otherwise.

Example

The following example shows how to retrieve names of indexes that belong to the class.

SELECT class_of.class_name, index_name

FROM _db_index

ORDER BY 1;

  class_of.class_name   index_name

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

  '_db_attribute'       'i__db_attribute_class_of_attr_name'

  '_db_auth'            'i__db_auth_grantee'

  '_db_class'           'i__db_class_class_name'

  '_db_domain'          'i__db_domain_object_of'

  '_db_index'           'i__db_index_class_of'

  '_db_index_key'       'i__db_index_key_index_of'

  '_db_meth_arg'        'i__db_meth_arg_meth_sig_of'

  '_db_meth_file'       'i__db_meth_file_class_of'

  '_db_meth_sig'        'i__db_meth_sig_meth_of'

  '_db_method'          'i__db_method_class_of_meth_name'

  '_db_partition'       'i__db_partition_class_of_pname'

  '_db_query_spec'      'i__db_query_spec_class_of'

  '_db_stored_procedure'  'u__db_stored_procedure_sp_name'

  '_db_stored_procedure_args'  'i__db_stored_procedure_args_sp_name'

  'athlete'             'pk_athlete_code'

  'db_serial'           'pk_db_serial_name'

  'db_user'             'i_db_user_name'

  'event'               'pk_event_code'

  'game'                'pk_game_host_year_event_code_athlete_code'

  'game'                'fk_game_event_code'

  'game'                'fk_game_athlete_code'

  'history'             'pk_history_event_code_athlete'

  'nation'              'pk_nation_code'

  'olympic'             'pk_olympic_host_year'

  'participant'         'pk_participant_host_year_nation_code'

  'participant'         'fk_participant_host_year'

  'participant'         'fk_participant_nation_code'

  'record'              'pk_record_host_year_event_code_athlete_code_medal'

  'stadium'             'pk_stadium_code'