abaindexdefinitions (ap_ixd)

Name

abaindexdefinitions

Code

ap_ixd

Creation Date

4 februari 2013 12:25:01

Modification Date

4 februari 2013 13:21:16

Comment

CREATE INDEX statements.


Table description

This table holds the definition of indexes and statistics known by AbaPerls. AbaPerls stores the indexes/statistics in two different ways:

 

Canonical - Scripted from the actual definition in the database, but including only storage properties owned by AbaPerls as defined in the table abaobjectstoragesettings.

Filetext - The actual text in the source files.

 

When AbaPerls reloads an index files, it compares the canonical definition to the current definition in the database, and the filetext to the current source text, and if both pairs are equal, the object is considered unchanged.

 

Note: this table was added in AbaPerls L1.0.0280, and for database created with earlier versions of AbaPerls, there may be indexes or statistics without data in this table.


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

objname

 

sysname

X

X

 

canonical

 

nvarchar(MAX)

X

 

 

filttext

 

nvarchar(MAX)

X

 

 


Keys

Name

Columns

Options

PK

pk_ap_ixd

objname clustered

X


Tables abaindexdefinitions refers to

Parent Table

Foreign Key Columns

abasysobjects

objname