Definition of table: UC_INDEX - internal information about UC4 indexes

generated: 09.12.2016 10:29:00
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
INDEX_Table Text 10 UC: Null=False Containing table
INDEX_Name Text 24 UC: Null=False Name of index
INDEX_Type Integer 2 UC: Null=True 1=normal, 2=unique, 3=primary key, 4=foreign key
INDEX_Fields Text 255 UC: Null=True Fields comma separated
INDEX_RefTable Text 10 UC: Null=True Foreign Key: Referencing Table
INDEX_RefFields Text 255 UC: Null=True Foreign Key: Referencing Fields


Indexes:

Name Fields
PK_INDEX INDEX_Table, INDEX_Name


Return to the Index File