# case sensitive tables

**URL:** <https://forum.liquibase.org/t/case-sensitive-tables/1214>\
**Category:** General Discussion\
**Created:** [April 5, 2011, 1:45am UTC](https://forum.liquibase.org/t/case-sensitive-tables/1214 "2011-04-05T01:45:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gooner89](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@gooner89](https://forum.liquibase.org/u/gooner89)\
**Post date:** [April 5, 2011, 1:45am UTC](https://forum.liquibase.org/t/case-sensitive-tables/1214/1 "2011-04-05T01:45:00Z")

</div>

If you run liquibase on HSQLDB to create a table named blob for example, it will generate the table “blob”. This is because blob is a keyword so the generated SQL looks something like CREATE TABLE “blob”, which in HSQLDB means the table will be in lowercase. Is there a way to specify that I want the tables to be in uppercase?(other than modifying the changeLogs)

---

<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:** [April 5, 2011, 1:45am UTC](https://forum.liquibase.org/t/case-sensitive-tables/1214/2 "2011-04-05T01:45:00Z")

</div>

Liquibase doesn’t do anything with the case of what is passed in. If you want the table uppercase, you either have to change it in the changelog file or create a custom subclass of HsqlDatabase that overrides the escapeDatabaseObject to uppercase it. See [liquibase.org/extensions](http://liquibase.org/extensions) on how to register custom databases.

Nathan

---

<div class="post-metadata">

**Author:** ![gooner89](https://avatars.discourse-cdn.com/v4/letter/g/77aa72/32.png) [@gooner89](https://forum.liquibase.org/u/gooner89)\
**Post date:** [April 5, 2011, 1:45am UTC](https://forum.liquibase.org/t/case-sensitive-tables/1214/3 "2011-04-05T01:45:00Z")

</div>

That makes total sense. Thanks! FYI I’ve decided just not to name the table names keywords like blob and property, just makes every1s life easier

Suneet
