# CreateSchema is emptying the database

**URL:** <https://forum.canton.network/t/createschema-is-emptying-the-database/827>\
**Category:** App Development\
**Tags:** daml-on-sql, json-api\
**Created:** [July 10, 2020, 3:29pm UTC](https://forum.canton.network/t/createschema-is-emptying-the-database/827 "2020-07-10T15:29:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bartcant](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/bartcant/32/823_2.png) [@bartcant](https://forum.canton.network/u/bartcant)\
**Post date:** [July 10, 2020, 3:29pm UTC](https://forum.canton.network/t/createschema-is-emptying-the-database/827/1 "2020-07-10T15:29:24Z")

</div>

At what point do I execute CreateSchema= true ?

when I startup my daml server ?

I see that at least 1 table is created in the database. I think 2 others but have not figured out which ones

also after I execute CreateSchema= true for a second time the content of this table seemed to have been wiped out

---

<div class="post-metadata">

**Author:** ![anthony](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/anthony/32/419_2.png) [@anthony](https://forum.canton.network/u/anthony)\
**Post date:** [July 10, 2020, 5:07pm UTC](https://forum.canton.network/t/createschema-is-emptying-the-database/827/2 "2020-07-10T17:07:01Z")

</div>

You would `CreateSchema=true` only the first time you initiate your database. Every time you run the command after that you’d want to use `CreateSchema=false` so it doesn’t wipe out the data.