# Liquibase Not Assigning Right Default Values to primary key columns in SQL Server database

**URL:** <https://forum.liquibase.org/t/liquibase-not-assigning-right-default-values-to-primary-key-columns-in-sql-server-database/4076>\
**Category:** General Discussion\
**Created:** [January 21, 2020, 3:54am UTC](https://forum.liquibase.org/t/liquibase-not-assigning-right-default-values-to-primary-key-columns-in-sql-server-database/4076 "2020-01-21T03:54:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [January 21, 2020, 3:54am UTC](https://forum.liquibase.org/t/liquibase-not-assigning-right-default-values-to-primary-key-columns-in-sql-server-database/4076/1 "2020-01-21T03:54:00Z")

</div>

Could you include the changelog that was created, the command you used, and details on the database platform?

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

**Author:** ![Dheeraj](https://avatars.discourse-cdn.com/v4/letter/d/c37758/32.png) [@Dheeraj](https://forum.liquibase.org/u/Dheeraj)\
**Post date:** [January 21, 2020, 3:54am UTC](https://forum.liquibase.org/t/liquibase-not-assigning-right-default-values-to-primary-key-columns-in-sql-server-database/4076/2 "2020-01-21T03:54:00Z")

</div>

Any information as to why liquibase does that and how to prevent it doing the above behavior ? I can’t find any mention of it in the docs or any other mention of this behavior online. We have several databases and manually fixing these changes will be a hurdle.