Azure表存储-删除列 [英] Azure Table Storage - remove columns

问题描述

我认为这是不可能的，但是我问了一个问题，也许我错过了一些事情.

I think this is not possible, but however I ask the question, maybe I have missed something.

我们可以从azure表中添加/删除列吗?

Can we add/remove columns from an azure table?

例如，默认情况下，我们得到以下列:PartitionKey，RowKey，Timestamp，ETag.例如，我可以添加其他3:名字，姓氏，电子邮件列吗?

For example by default we get those columns: PartitionKey, RowKey, Timestamp, ETag. Can I add for example another 3: FirstName, LastName, Email columns?

在那之后，我将插入一些值，并且我想删除列电子邮件，而改为添加地址列.我们可以做到吗?

After that I will insert some values and I want to remove column Email and add instead column Address. Can we do this?

推荐答案

Azure表不像SQL表那样具有列". Azure表具有实体.每个实体最多具有255个属性.大多数可让您查看Azure表的工具都选择将其表中的数据可视化为带有列的表格.但是，实际上，每个实体(行)都是属性的集合.

Azure Tables do not have "columns" as SQL tables do. Azure Tables have entities. Each entity has up to 255 properties. Most tools that let you look at an Azure table, choose to visualize the data in it tabular with columns. However, in reality, each entity (row) is a collection of properties.

因此，每次执行保存操作时，都可以将对象/实体保存到具有不同属性的Azure表中.它使事情有些混乱，但是您可以做到.

Therefore, you can save objects/entities into an Azure Table with different properties, everytime you do a save. It makes things somewhat confusing, but you can do it.

HTH

这篇关于Azure表存储-删除列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！