# sqlfile tag in formatted Sql file

**URL:** <https://forum.liquibase.org/t/sqlfile-tag-in-formatted-sql-file/3394>\
**Category:** General Discussion\
**Created:** [August 4, 2016, 11:22am UTC](https://forum.liquibase.org/t/sqlfile-tag-in-formatted-sql-file/3394 "2016-08-04T11:22:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![NagmaFan](https://avatars.discourse-cdn.com/v4/letter/n/f04885/32.png) [@NagmaFan](https://forum.liquibase.org/u/NagmaFan)\
**Post date:** [August 4, 2016, 11:22am UTC](https://forum.liquibase.org/t/sqlfile-tag-in-formatted-sql-file/3394/1 "2016-08-04T11:22:00Z")

</div>

Hi,  
I have got a formatted Sql file with all the CREATE and ALTER table statements.  
But some statements are in an external file. What is the syntax for sqlFile tag in Liquibase formatted sql file?

Thanks,  
Nagma.

---

<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:** [August 4, 2016, 11:22am UTC](https://forum.liquibase.org/t/sqlfile-tag-in-formatted-sql-file/3394/2 "2016-08-04T11:22:00Z")

</div>

There isn’t really an equivalent - you would have to use database specific techniques. I searched for “[Use One SQL file from another](https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=use%20one%20sql%20file%20from%20another)” and found some results. For example, if you are using MSSQL, you could do this:

[http://stackoverflow.com/questions/5237198/transactsql-to-run-another-transactsql-script](http://stackoverflow.com/questions/5237198/transactsql-to-run-another-transactsql-script)

If using Oracle, here are some ideas:

[http://stackoverflow.com/questions/24119041/run-sqlplus-script-that-runs-other-script-files](http://stackoverflow.com/questions/24119041/run-sqlplus-script-that-runs-other-script-files)

Because Liquibase executes SQL using JDBC calls rather than native tools (i.e. sqlcmd or sqlplus) you may run into difficulties with either of these techniques.

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