LOCALINDEXATOMS System Table Description

Description

A pseudo table generated for internal debugging purposes only. This table does not provide much information for users. It contains information about all NuoDB atoms used in indexes, and in particular information about their encoding.

Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

Fields

Field Type Description

SCHEMA

string

The schema in which the index was created

TABLENAME

string

The table name on which the index exists

INDEXNAME

string

The name of the index

OBJECTID

integer

The ID for the database object

CATALOGID

integer

The catalog ID for the database object

ENCODING

string

An internal string representing the encoding used for this index.

CODE

integer

A value which maps to the index type.

ENCODINGTYPE

string

LOSSLESS or LOSSY

FLAGS

integer

Bitmask where:

  • 1 = always auto generated

TYPE

integer

Index type:

  • 0 = Primary Key

  • 1 = Unique Index

  • 2 = Secondary Index

Indexes

None