# Ant- update database outputDefaultSchema property

**URL:** <https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878>\
**Category:** General Discussion\
**Created:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878 "2014-02-04T12:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![FernandoBoucquez](https://avatars.discourse-cdn.com/v4/letter/f/9d8465/32.png) [@FernandoBoucquez](https://forum.liquibase.org/u/FernandoBoucquez)\
**Post date:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878/1 "2014-02-04T12:00:00Z")

</div>

Hi all, first, thanks for the great tool!

I am generating a release script using ant database update and the outputFile attribute. The problem I have is ant is generating the script prefixing the schema name to all the commands.

e.g:

CREATE SEQUENCE **UAT**.hibernate\_sequence;

[http://www.liquibase.org/documentation/ant/updatedatabase\_ant\_task.html](http://www.liquibase.org/documentation/ant/updatedatabase_ant_task.html)

I am trying to set the&nbsp;

---

<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:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878/2 "2014-02-04T12:00:00Z")

</div>

It looks like it didn’t make it to the ant scripts yet. I created&nbsp;[https://liquibase.jira.com/browse/CORE-1758](https://liquibase.jira.com/browse/CORE-1758) to track the problem.

However, the outputDefaultSchema flag is just used in generating the changelog from an existing database. If you don’t want to hard-code the schema, you can strip out the catalogName and schemaName attributes with a search/replace.&nbsp;

Once they are out of the changelog file, the generated SQL will not have them specified.

Nathan

---

<div class="post-metadata">

**Author:** ![un1391485510750r6id](https://avatars.discourse-cdn.com/v4/letter/u/c37758/32.png) [@un1391485510750r6id](https://forum.liquibase.org/u/un1391485510750r6id)\
**Post date:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878/3 "2014-02-04T12:00:00Z")

</div>

Thanks Nathan, I’ll do the find and replace.

---

<div class="post-metadata">

**Author:** ![viper2843](https://avatars.discourse-cdn.com/v4/letter/v/e19b73/32.png) [@viper2843](https://forum.liquibase.org/u/viper2843)\
**Post date:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878/4 "2014-02-04T12:00:00Z")

</div>

Pull request for adding the flags to the ant task.  
  
[https://github.com/liquibase/liquibase/pull/242](https://github.com/liquibase/liquibase/pull/242)

---

<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:** [February 4, 2014, 12:00pm UTC](https://forum.liquibase.org/t/ant-update-database-outputdefaultschema-property/2878/5 "2014-02-04T12:00:00Z")

</div>

Thanks, I’ll take a look at the pull request.

Nathan