# Don't use space in Local SQL DB table's column name **URL:** \ **Category:** Schema & Data\ **Created:** [November 25, 2014, 7:48am UTC](https://community.dreamfactory.com/t/dont-use-space-in-local-sql-db-tables-column-name/576 "2014-11-25T07:48:25Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sandy\_8925](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@sandy\_8925](https://community.dreamfactory.com/u/sandy_8925)\ **Post date:** [November 25, 2014, 7:48am UTC](https://community.dreamfactory.com/t/dont-use-space-in-local-sql-db-tables-column-name/576/1 "2014-11-25T07:48:25Z")
Unfortunately, the DreamFactory UI doesn’t automatically detect whether or not your column name has spaces - it will allow you to enter them as is. I encountered this after creating a new table, adding columns, creating one column called “Phone number” I went to the Data tab, and tried to load the (empty) table, and an error occurred - it complained about a missing “Phone” column. I immediately realized that it was referring to the “Phone number” column and that I had mistakenly used spaces in it. So, I went back and changed it. ---
**Author:** ![toddappleton](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/toddappleton/32/159_2.png) [@toddappleton](https://community.dreamfactory.com/u/toddappleton)\ **Post date:** [November 25, 2014, 11:09pm UTC](https://community.dreamfactory.com/t/dont-use-space-in-local-sql-db-tables-column-name/576/2 "2014-11-25T23:09:20Z")
I would use this: field name = "phone\_number" field label = “Phone Number” ---
**Author:** ![sandy\_8925](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@sandy\_8925](https://community.dreamfactory.com/u/sandy_8925)\ **Post date:** [November 27, 2014, 7:22am UTC](https://community.dreamfactory.com/t/dont-use-space-in-local-sql-db-tables-column-name/576/3 "2014-11-27T07:22:35Z")
Thank you, that’s what I ended up using.