# GenerateChangeLog - Sybase - Ignores IDENTITY and Column defaults

**URL:** <https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884>\
**Category:** General Discussion\
**Created:** [October 27, 2010, 4:17pm UTC](https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884 "2010-10-27T16:17:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vvootla](https://avatars.discourse-cdn.com/v4/letter/v/a8b319/32.png) [@vvootla](https://forum.liquibase.org/u/vvootla)\
**Post date:** [October 27, 2010, 4:17pm UTC](https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884/1 "2010-10-27T16:17:00Z")

</div>

I’m a new liquibase user and using it against a Sybase IQ database. IQ supports Sybase ASE DDL for most part and so I had extended SybaseDatabase class to define SystemTablesAndViews,&nbsp; isSybaseProductName() and getDefaultDriver(). The generateChangeLog both ant and command line versions generates all&nbsp; objects but seems to ignore extracting IDENTITY and DEFAULT value details of the columns. Are there any other methods I need to override or define on my databaseClass if I want the IDENTITY and column defaults to be picked up? Or is this a known issue with SybaseDatabase support itself?

Specifically I have a table

CREATE TABLE MyTask&nbsp; (  
taskId&nbsp; &nbsp; &nbsp; &nbsp; integer IDENTITY NOT NULL,  
taskName&nbsp; &nbsp; char(64) NULL,  
taskStatus&nbsp; &nbsp; char(8) NULL,  
createDate&nbsp; &nbsp; &nbsp; timestamp NOT NULL DEFAULT timestamp,  
PRIMARY KEY(taskId)  
)  
GO

output of GenerateChangeLog:

&nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp;

No autoincrement or defaultValue specifications are extracted into the changelog schema.

Thanks,  
-Prasad

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 27, 2010, 4:17pm UTC](https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884/2 "2010-10-27T16:17:00Z")

</div>

Are you using liquibase 1.9 or 2.0?

Nathan

---

<div class="post-metadata">

**Author:** ![vvootla](https://avatars.discourse-cdn.com/v4/letter/v/a8b319/32.png) [@vvootla](https://forum.liquibase.org/u/vvootla)\
**Post date:** [October 27, 2010, 4:17pm UTC](https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884/3 "2010-10-27T16:17:00Z")

</div>

LiquiBase\_2.0\_RC6.

The utility I’m building is to re-create ‘production’ schema into the test environments for our periodic regression testing purposes. And for this it is important that the generated schema be very faithful to the one in prod.

Thanks  
-Prasad

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 27, 2010, 4:17pm UTC](https://forum.liquibase.org/t/generatechangelog-sybase-ignores-identity-and-column-defaults/884/4 "2010-10-27T16:17:00Z")

</div>

The main class used for creating the snapshot is an implementation of DatabaseSnapshotGenerator.&nbsp; Sybase uses the default StandardJdbcDatabaseSnapshotGenerator, so you may need to create a custom subclass and override the isColumnAutoIncrement method with custom logic.

Nathan