# Adding a new item to the Database Schema

**URL:** <https://forum.inductiveautomation.com/t/adding-a-new-item-to-the-database-schema/10534>\
**Category:** Ignition\
**Created:** [September 28, 2015, 2:14pm UTC](https://forum.inductiveautomation.com/t/adding-a-new-item-to-the-database-schema/10534 "2015-09-28T14:14:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lar\_Mag](https://avatars.discourse-cdn.com/v4/letter/l/c67d28/32.png) [@Lar\_Mag](https://forum.inductiveautomation.com/u/Lar_Mag)\
**Post date:** [September 28, 2015, 2:14pm UTC](https://forum.inductiveautomation.com/t/adding-a-new-item-to-the-database-schema/10534/1 "2015-09-28T14:14:35Z")

</div>

I have inherited an ignition application that requires a few modifications.  
On one of the windows the Label text is binding/ linked to a Dynamic Dataset called “state”.  
This Dynamic Dataset is binding/linked using the SQL Query.  
When I Select Tools -\> Database Query Browser  
I can see a list of “Schema” on the right hand side.

My question is how do I add a new item to the Schema tab?

---

<div class="post-metadata">

**Author:** ![JGJohnson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jgjohnson/32/29582_2.png) [@JGJohnson](https://forum.inductiveautomation.com/u/JGJohnson)\
**Post date:** [September 28, 2015, 2:58pm UTC](https://forum.inductiveautomation.com/t/adding-a-new-item-to-the-database-schema/10534/2 "2015-09-28T14:58:09Z")

</div>

This should be done using the management tools for the database.

For MSSQL you would use SQL Server Management Studio. For Oracle I believe it would be Oracle SQL Developer. For other databases I don’t know.

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [September 28, 2015, 6:29pm UTC](https://forum.inductiveautomation.com/t/adding-a-new-item-to-the-database-schema/10534/3 "2015-09-28T18:29:09Z")

</div>

The ‘Schema’ list actually shows the list of tables in the currently selected database. You can add a new table using the Database Query Browser as long as the Designer is set to read/write mode.

For help with the syntax to add a table using SQL have a look at [http://www.w3schools.com/sql/sql\_create\_table.asp](http://www.w3schools.com/sql/sql_create_table.asp)