# Does Liquibase support ROWVERSION for SQL Server 2008?

**URL:** <https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694>\
**Category:** General Discussion\
**Created:** [November 2, 2011, 9:21pm UTC](https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694 "2011-11-02T21:21:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [November 2, 2011, 9:21pm UTC](https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694/1 "2011-11-02T21:21:00Z")

</div>

I am&nbsp;evaluating Liquibase for a new project we are starting and in the process I have run into a snag.

To track changes to rows in our tables we are going to use the ROWVERSION data type.

When I attempt to create a table with the ROWVERSION datatype in my change log, I see that the table is actually created in the database with a TIMESTAMP data type.

This is a deprecated data type and we don’t want to use it.

I really don’t want to have to resort to running a custom SQL tag after every table create to get this in. &nbsp;Is there another way around this problem?

Our system will be using Microsoft SQL Server 2008 R2 and I generated this using Liquibase 2.0.2.

---

<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:** [November 2, 2011, 9:21pm UTC](https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694/2 "2011-11-02T21:21:00Z")

</div>

&nbsp;I’m not seeing a reference to rowversion in the code, which should mean it would be created as rowversion and not converted to timestamp. You are seeing it as timestamp in management studio or with a database diff?

Nathan

---

<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:** [November 2, 2011, 9:21pm UTC](https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694/3 "2011-11-02T21:21:00Z")

</div>

Great. Thanks for the update

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [November 2, 2011, 9:21pm UTC](https://forum.liquibase.org/t/does-liquibase-support-rowversion-for-sql-server-2008/1694/4 "2011-11-02T21:21:00Z")

</div>

I&nbsp;apologize&nbsp;Nathan, the use of the&nbsp;synonym&nbsp;in Management Studio is what was confusing me.

The datatype shows up as a timestamp in the Management Studio, but this is a&nbsp;synonym&nbsp;for actual rowversion datatype.

Liquibase is behaving as it should.