I want to delete some unnecessary columns which are created but not using currently. Without deleting the table data or table in Microsoft azure storage explorer how can I delete columns manually?
2
votes
3 Answers
2
votes
Mildly annoying but you can fix the issue by deleting the entire contents of:
AppData\Roaming\StorageExplorer
that will fix the issue. You'll need to reauthorized the accounts but that's a mild inconvenience. There's likely a file or two within that directory that actually caches that data that is a more surgical approach but the few most obvious candidates didn't work for me so i just deleted the whole directory.
1
votes
It's not possible to delete columns for all entities in a table, since Azure Storage Table is a schema-less database. In other words, the entities within a table can have different properties respectively. You have to query all the entities, remove the useless properties from them one by one and then replace the modified entities back to the table.
0
votes
I've found that if you copy the table and paste it into a different storage account or simply rename the table then the new table will not reference the unused columns. However, if you paste it back to the original location or rename the table back to the original name then the unused columns will still be shown, even if you delete the table first.
Strangely, if you create a brand new table with the same name it will only have the default columns. But import the contents of the original table from file and the superfluous columns will also reappear even though there is no reference to those columns in the csv file.
