# Can't delete column

**URL:** <https://forum.servoy.com/t/cant-delete-column/16324>\
**Category:** Classic Servoy\
**Created:** [August 8, 2012, 4:22pm UTC](https://forum.servoy.com/t/cant-delete-column/16324 "2012-08-08T16:22:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JonathonBevan1342106235](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@JonathonBevan1342106235](https://forum.servoy.com/u/JonathonBevan1342106235)\
**Post date:** [August 8, 2012, 4:22pm UTC](https://forum.servoy.com/t/cant-delete-column/16324/1 "2012-08-08T16:22:28Z")

</div>

Hi

Am I doing something wrong? See the attached image - I cannot do three things on this screen (looking at table ‘Project’) that I was expecting.

1. A delete button so I can delete a column in the table…
2. I cannot tag a column to not allow nulls.
3. Minor - but I cannot reorder the columns.

I have really been fighting with problems today and would really appreciate someones help.

Kind Regards  
Jonathon

 ![NoDelete.gif](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/6/64738054ea382d90e2dd76abfa3df2e5144a3e85.gif)

---

<div class="post-metadata">

**Author:** ![omar](https://avatars.discourse-cdn.com/v4/letter/o/f0a364/32.png) [@omar](https://forum.servoy.com/u/omar)\
**Post date:** [August 8, 2012, 7:27pm UTC](https://forum.servoy.com/t/cant-delete-column/16324/2 "2012-08-08T19:27:14Z")

</div>

Jonathon,

1. Red X deletes the column ![:D]( "Very Happy")
2. Try it on a new table or a table without data
3. No can do.

Cheers,

---

<div class="post-metadata">

**Author:** ![JonathonBevan1342106235](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@JonathonBevan1342106235](https://forum.servoy.com/u/JonathonBevan1342106235)\
**Post date:** [August 9, 2012, 11:04am UTC](https://forum.servoy.com/t/cant-delete-column/16324/3 "2012-08-09T11:04:42Z")

</div>

Hi Omar

The delete button wasn’t where I expected - LOL - thanks… I expected the button to be close to the “add button”…

I still cannot set a column to Not Except Null???

I tested SQL explorer on the sample databases and it worked well. SO it suggested that my table was some what corrupted. How did I fix it? I deleted all the records - that did not work on its own. I copied the table. Deleted the original. Renamed the copy back to its original name. Then the SQL data tab worked. I lost my calculations. Is there a better way of fixing corrupt tables? I hope this doesn’t happen often on live data?

Spending a lot of time NOT developing - hitting issues. ![:(]( "Sad") I hope I am just being a little unlucky.

Thanks ![:)]( "Smile") and Cheers  
Jonathon

---

<div class="post-metadata">

**Author:** ![omar](https://avatars.discourse-cdn.com/v4/letter/o/f0a364/32.png) [@omar](https://forum.servoy.com/u/omar)\
**Post date:** [August 9, 2012, 11:24am UTC](https://forum.servoy.com/t/cant-delete-column/16324/4 "2012-08-09T11:24:58Z")

</div>

Hi Jonathon,

There are some restrictions to when you can set a column to null. I did a little test where I could set the column to null:

1. Create a new table (through the Servoy interface)
2. Besides the PK which is generated for you add a new column and give it a name
3. Now you should be able to check Allow Nulls

I have never had corrupted data with postgreSQL. Be careful with making changes to the database outside of Servoy. If you do then do the following (if neccessary):

1. Right-click the database connection
2. From the popup menu choose “Reload tables/table structure from DB”
3. Select the option “Synchronize with DB server information”
4. If records have been added outside of Servoy also select “Update Servoy Sequences”