# Transaction groups Tables **URL:** \ **Category:** General Discussion\ **Tags:** ignition78\ **Created:** [August 29, 2018, 3:50pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447 "2018-08-29T15:50:01Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [August 29, 2018, 3:50pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447/1 "2018-08-29T15:50:01Z")
How do you delete a table from the server, add or change one of the column titles. I had to add another tag to my transaction group but it won’t show up in my data table. I have to create a new table which will then add it. I did not find any answers on the inductive automation university lessons either. It would also help if someone could tell me how to change the column size or center up the data in the column. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 29, 2018, 4:16pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447/2 "2018-08-29T16:16:37Z")
> [@christopher.raphael](#): > > How do you delete a table from the server, add or change one of the column titles. Normally one would do minor DB maintenance from your branded DB management studio, though if you know the actual SQL syntax, you can run ALTER TABLE statements from the Query Browser. > [@christopher.raphael](#): > > I had to add another tag to my transaction group but it won't show up in my data table. I have to create a new table which will then add it. The 'create table automatically' checkbox in the transaction group editor will create a table from scratch with your desired columns, or add new columns to existing tables. It will not delete or rename columns, nor delete or rename tables. It will also not necessarily produce the best indexing strategy for the table, as that can vary by brand. > [@christopher.raphael](#): > > I did not find any answers on the inductive automation university lessons either. IA University isn't really intended to teach database administration, and since IA supports many different DBs, it'd be rather difficult. Consult you chosen DB's documentation/tutorials/tools/training. > [@christopher.raphael](#): > > It would also help if someone could tell me how to change the column size or center up the data in the column. This isn't a data storage question, but a data display question. When you have the data you wish showing in a table, use the table customizer to adjust the column alignment and date/numeric formatting. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [August 29, 2018, 5:05pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447/3 "2018-08-29T17:05:46Z")
So basically there is no function in ignition itself to remove a db table created with a transaction group without going into the server itself. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [August 29, 2018, 7:45pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447/4 "2018-08-29T19:45:03Z")
Next question, how do i reverse the order in a table so it shows the most recent addition first. ---
**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\ **Post date:** [August 29, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-tables/19447/5 "2018-08-29T20:36:31Z")
> [@christopher.raphael](#): > > So basically there is no function in ignition itself to remove a db table created with a transaction group without going into the server itself. You can go to the database server or you can use the Query Browser as @pturmel mentioned, or you can use a DB management studio on your machine that's connected to the database server, or you can write a script in Ignition. Tons of options for removing your old data. The most common use case for deleting data is to truncate after a certain period of time, and that functionality is available in the transaction group. For a one time delete such as your case, you will need to do one of the options above. > [@christopher.raphael](#): > > Next question, how do i reverse the order in a table so it shows the most recent addition first. Add an ORDER BY clause, such as ORDER BY t\_stamp desc