Name Type MSSql Type Oracle Type DB2 Nullable Description
DIVDB_PK int NUMBER(38,0) int false primary key
DIVDB_Int1 smallint NUMBER(38,0) smallint true byte value
DIVDB_Int2 smallint NUMBER(38,0) smallint true integer value
DIVDB_Int4 int NUMBER(38,0) int true long integer value
DIVDB_Memo varbinary(256) RAW(256) varchar(256) for bit data true memo field
DIVDB_Date datetime DATE timestamp true date/time field
DIVDB_String varchar (255) VARCHAR2 (255 CHAR) varchar(255) true character field (length=255)
DIVDB_String2 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true character field (length=255)
DIVDB_String3 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true character field (length=255)
DIVDB_CLOB varchar(5000) CLOB varchar(5000) true Long string
DIVDB_BLOB varbinary(max) BLOB blob(128 M) INLINE LENGTH 1024 COMPACT true for binary

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_DIVDB DIVDB_PK true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File