| 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 |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_INDEX | INDEX_Table, INDEX_Name | true | true | true | false |
| Name | Local References | Foreign References |
|---|
Return to the Index File