arg_index_def

Contains information about database index definitions

Column Name Column Datatype Column Null Option Column Comment
index_name nvarchar(32) not null Name of the index. Primary key. Unique.
index_description nvarchar(255) with null Index description.
table_name nvarchar(32) with null Name of the table to which the index belongs. Foreign key to arg_table_def table.
index_primary smallint with null Flag representing whether the index is the primary index. 0=False (not primary), 1=True (primary)
index_unique smallint with null Flag representing whether the index is a unique index. 0=False (not unique), 1=True (unique)
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process who last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.

Product Name: Unicenter Asset Portfolio Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.