# How to rollback changeSetId using SQL Dialect

**URL:** <https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081>\
**Category:** General Discussion\
**Tags:** rollback, xml\
**Created:** [July 16, 2022, 1:57am UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081 "2022-07-16T01:57:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![whitford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/whitford/32/798_2.png) [@whitford](https://forum.liquibase.org/u/whitford)\
**Post date:** [July 16, 2022, 1:57am UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081/1 "2022-07-16T01:57:21Z")

</div>

I am intrigued by the [rollback capability](https://docs.liquibase.com/commands/rollback/rollback-by-tag.html) that allows you to reference the changeset that originally created a statement:

```auto
<changeSet id="changeRollback2-drop" author="liquibase">
  <dropTable tableName="changeRollback2"/>
  <rollback changeSetId="changeRollback2-create" changeSetAuthor="liquibase"/>
</changeSet>

```

How can we do this using the SQL Dialect?

---

<div class="post-metadata">

**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\
**Post date:** [July 18, 2022, 2:04pm UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081/2 "2022-07-18T14:04:33Z")

</div>

Welcome whitford.

Rollback to changeSetId is currently only availabe in XML changelogs.

---

<div class="post-metadata">

**Author:** ![whitford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/whitford/32/798_2.png) [@whitford](https://forum.liquibase.org/u/whitford)\
**Post date:** [July 21, 2022, 7:54am UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081/3 "2022-07-21T07:54:33Z")

</div>

Thanks for confirming. I found an [open issue](https://github.com/liquibase/liquibase/issues/1335) – with a [PR](https://github.com/liquibase/liquibase/pull/1386)! 🤞

---

<div class="post-metadata">

**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\
**Post date:** [July 21, 2022, 1:26pm UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081/4 "2022-07-21T13:26:24Z")

</div>

LOL The guy that opened that PR works at my company.

---

<div class="post-metadata">

**Author:** ![atzawada](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@atzawada](https://forum.liquibase.org/u/atzawada)\
**Post date:** [August 19, 2022, 9:26pm UTC](https://forum.liquibase.org/t/how-to-rollback-changesetid-using-sql-dialect/7081/5 "2022-08-19T21:26:56Z")

</div>

Lol. Hey Daryl. That PR never got much traction…I am still willing to help get it into the mainline if a maintainer takes any interest.