Example documentationINDEXCOLUMNS Locate this document in the navigation structure

 

Use of the system table DOMAIN.INDEXCOLUMNS

Prerequisites

You can use the demo data for the SQL tutorial. Start the Database Studio as database administrator MONA with the password RED and log on to demo database DEMODB: Logging On to a Database.

Create indexes. Proceed as described in SQL Tutorial, Indexes.

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

You can use the system table INDEXCOLUMNS to determine the following database information, among other things:

  • All indexed columns of the table CUSTOMER

    SELECT DISTINCT columnname

    FROM DOMAIN.INDEXCOLUMNS

    WHERE tablename = 'CUSTOMER'

  • All inversions for the table CUSTOMER, sorted according to the name of the index and there according to the sequence of columns as specified in the index definition

    SELECT indexname, type, columnname, sort

    FROM DOMAIN.INDEXCOLUMNS

    WHERE tablename = 'CUSTOMER' ORDER BY indexname, columnno

  • Information about the columns that comprise the ADDRESS_INDEX of the table CUSTOMER

    SELECT columnname, sort, datatype, len

    FROM DOMAIN.INDEXCOLUMNS

    WHERE indexname = 'ADDRESS_INDEX' ORDER BY columnno

More Information

All Indexes: see INDEXES