meta_Indexes - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

meta_Indexes

Returns the indices (primary, secondary, hash, join, and so on) defined for the current tables in the repository. Corresponds to the relationships TableHasIndexes, DatabaseHasHashIndexes, and DatabaseHasJoinIndexes.

 

Table 98: Columns, Data Types, and Values of the meta_Indexes View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

TableName

VARCHAR(128)

 

IndexName

VARCHAR(128)

 

IndexLOID

INTEGER

 

IndexType

CHAR(1)

 

IndexTypeA

VARCHAR(35)

  • Primary
  • Partition Primary
  • Secondary
  • Join
  • Hash
  • Primary Key
  • Unique Constraint
  • Value ordered secondary
  • Hash ordered ALL secondary
  • Value ordered ALL secondary
  • Ordering column
  • Multi-column statistics
  • Derived column partition statistics
  • Field1 of hash/join
  • Field2 of hash/join
  • IsUnique

    VARCHAR(3)

     

    IndexNumber

    SMALLINT