Table UC_INDEX

Definition of table: UC_INDEX - internal information about UC4 indexes

generated: 12.12.2016 18:34:44
by UC2010.accdb

AE Database 11.2 (Step 018)

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

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

Name	Fields
PK_INDEX	INDEX_Table, INDEX_Name

Return to the Index File