Rename an Azure Storage Table programmatically

Question

Is there a way to rename an Azure Storage Table programmatically?

I regularly delete Tables with data that's not used anymore but I might start to save it for longer. To avoid messing with a working system (it's checking for those tables to generate data) I would like to just rename them or do some sort of copy instead of just deleting.

Is there a way to do this with Azure Storage Tables?

score 2 · Answer 1 · answered Sep 24 '14 at 15:20

2

It is not possible to rename Azure Storage table. The only thing you can do is to download all entities from the table you want to rename and then upload them to new table with your new name

answered Sep 24 '14 at 15:20

Karpukhin Olexiy

111
5

score 1 · Accepted Answer · edited May 23 '17 at 12:34

1

It would seem that someone has answered this elsewhere now: Rename Azure Storage Table?

Currently it isn't possible.

edited May 23 '17 at 12:34

Community

1
1

answered Feb 04 '14 at 12:04

user2413912

579
6
19

score -2 · Answer 3 · answered Dec 08 '13 at 23:13

-2

Try,

EXEC sp_rename 'oldTableName', 'newTableName'

Note: This simple method uses the built-in stored procedure to do the renaming. You can use the same method to rename columns inside the table (use table.column)

answered Dec 08 '13 at 23:13

MunsterMan

307
1
8

Thank you, but I believe there's a misunderstanding here. I'm not trying to do renaming in SQL Server/Database but on Azure Storage Tables which is something different and to my knowledge do not have that option. – user2413912 Dec 09 '13 at 12:45

Rename an Azure Storage Table programmatically

3 Answers3