Apache DB | DdlUtils | for

Home

Section |
apache.org > db > ddlutils | PDF
## Sybase DdlUtils supports the Sybase products SQL Server from version 10.0 on, and Adaptive Server Enterprise from version 11.5 on. The Sybase documentation can be found in the Archive in the Transact-SQL User's Guide document for the respective version. The manual for the newest version is found here. Platform identifier: Sybase Recognized JDBC drivers: com.sybase.jdbc2.jdbc.SybDriver com.sybase.jdbc.SybDriver Recognized JDBC sub protocol: jdbc:sybase:Tds
The database supports SQL comments | yes
The database supports delimited identifiers | yes
The database's maximum identifier length | 28
The database supports default values for LONG types | yes
DdlUtils uses sequences for identity columns | no
The database supports non-primary key columns as identity columns | yes
The database allows INSERT/UPDATE statements to set values for identity columns | yes
DdlUtils can read back the auto-generated value of an identity column | yes
The database supports non-unique indices | yes
DdlUtils can create a database via JDBC | no
DdlUtils can drop a database via JDBC | no
JDBC Type | Database Type | Additional comments
--- | --- | ---
ARRAY | IMAGE | Will be read back as LONGVARBINARY
BIGINT | DECIMAL(19,0) |
BINARY | BINARY |
BIT | SMALLINT | The native BIT type is rather limited (cannot be NULL, cannot be indexed), hence DdlUtils uses SMALLINT instead. Will be read back as SMALLINT
BLOB | IMAGE | Will be read back as LONGVARBINARY
BOOLEAN | SMALLINT | The native BIT type is rather limited (cannot be NULL, cannot be indexed), hence DdlUtils uses SMALLINT instead. Will be read back as SMALLINT
CHAR | CHAR |
CLOB | TEXT | Will be read back as LONGVARCHAR
DATALINK | IMAGE | Will be read back as LONGVARBINARY
DATE | DATETIME | Will be read back as TIMSTAMP
DECIMAL | DECIMAL |
DISTINCT | IMAGE | Will be read back as LONGVARBINARY
DOUBLE | DOUBLE PRECISION |
FLOAT | DOUBLE PRECISION | Will be read back as DOUBLE
INTEGER | INT |
JAVA_OBJECT | IMAGE | Will be read back as LONGVARBINARY
LONGVARBINARY | IMAGE |
LONGVARCHAR | TEXT |
NULL | IMAGE | Will be read back as LONGVARBINARY
NUMERIC | NUMERIC |
OTHER | IMAGE | Will be read back as LONGVARBINARY
REAL | REAL |
REF | IMAGE | Will be read back as LONGVARBINARY
SMALLINT | SMALLINT |
STRUCT | IMAGE | Will be read back as LONGVARBINARY
TIME | DATETIME | Will be read back as TIMESTAMP
TIMESTAMP | DATETIME | Will be read back as TIMESTAMP
TINYINT | SMALLINT | The native TINYINT type only supports values between 0 and 255. Will be read back as SMALLINT
VARBINARY | VARBINARY |
VARCHAR | VARCHAR |