Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
INDEX_Table varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) false Containing table
INDEX_Name varchar (24) VARCHAR2 (24 CHAR) varchar(24) varchar (24) false Name of index
INDEX_Type smallint NUMBER(38,0) smallint smallint true 1=normal, 2=unique, 3=primary key, 4=foreign key
INDEX_Fields varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Fields comma separated
INDEX_RefTable varchar (10) VARCHAR2 (10 CHAR) varchar(10) varchar (10) true Foreign Key: Referencing Table
INDEX_RefFields varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Foreign Key: Referencing Fields

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_INDEX INDEX_Table, INDEX_Name true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File