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. |
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. |
|
|
Data |
NOT |
F |
|
objname |
|
sysname |
X |
X |
|
canonical |
|
nvarchar(MAX) |
X |
|
|
filttext |
|
nvarchar(MAX) |
X |
|
|
Name |
Columns |
Options |
PK |
pk_ap_ixd |
objname | clustered |
X |
Parent Table |
Foreign Key Columns |
objname |
|
|
|