# generatechangelog creates changelog with most tables without column

**URL:** <https://forum.liquibase.org/t/generatechangelog-creates-changelog-with-most-tables-without-column/2815>\
**Category:** General Discussion\
**Created:** [December 24, 2013, 8:54am UTC](https://forum.liquibase.org/t/generatechangelog-creates-changelog-with-most-tables-without-column/2815 "2013-12-24T08:54:00Z")\
**Posts on this page:** 3\
**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:** [December 24, 2013, 8:54am UTC](https://forum.liquibase.org/t/generatechangelog-creates-changelog-with-most-tables-without-column/2815/1 "2013-12-24T08:54:00Z")

</div>

Hi, I have an existing SQL Server 2008 R2 database with many tables. The generatechangelog command (I am running via Maven, if that helps) generates the list of all tables, with primary keys, indexes and views.

Out of all the createTable tags all except one have columns in them in the changelog, but in the database all tables have columns.

I am using liquibase 3.0.8 and sqljdbc4, any idea why this is happening?

---

<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:** [December 24, 2013, 8:54am UTC](https://forum.liquibase.org/t/generatechangelog-creates-changelog-with-most-tables-without-column/2815/2 "2013-12-24T08:54:00Z")

</div>

I’m not sure why you are seeing this. It works fine for me in my testing. Is there anything you notice that all the missing columns have in common?  
  
Nathan

---

<div class="post-metadata">

**Author:** ![un1408988134478r54id](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@un1408988134478r54id](https://forum.liquibase.org/u/un1408988134478r54id)\
**Post date:** [December 24, 2013, 8:54am UTC](https://forum.liquibase.org/t/generatechangelog-creates-changelog-with-most-tables-without-column/2815/3 "2013-12-24T08:54:00Z")

</div>

Were you ever able to resolve this? I’m running into a similar issue now using Liquibase 3.2.2 and MySQl 5.6. &nbsp;Out of approximately 200 tables in my database (all of which have columns), only 2 show up with columns in the changeLog.xml.

Otherwise I just see a bunch of the following:

1.  
2. &nbsp; &nbsp; 
3. &nbsp; &nbsp; &nbsp; &nbsp; 
4. &nbsp; &nbsp;