Table column definitions messages

A column is a container for a piece of data in a table. The term attribute and property (class property) are often used interchangeably with the term table column. Model-driven apps use the term column when they refer to table columns.

Note

Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.

Note

It is possible to create and update table columns using the Web API. See Create columns for more details.

Table column messages

The following table lists the messages that you can use to perform actions on table columns.

Message Web API Operation SDK Assembly
CreateAttribute

Create table columns
POST to EntityMetadata Attributes collection-valued navigation property with JSON definition of column. More information: Create columns CreateAttributeRequest
DeleteAttribute

Delete table columns
DELETE to the URL of the column. DeleteAttributeRequest
DeleteOptionValue

Delete a choice from PicklistAttributeMetadata or StatusAttributeMetadata columns
DeleteOptionValue Action DeleteOptionValueRequest
InsertOptionValue

Add a choice to a PicklistAttributeMetadata column
InsertOptionValue Action InsertOptionValueRequest Add a choice to a PicklistAttributeMetadata column.
InsertStatusValue

Add a choice to a StatusAttributeMetadata column
InsertStatusValue Action InsertStatusValueRequest Changes the order of the choice presented in an PicklistAttributeMetadata column OrderOption Action OrderOptionRequest
RetrieveAttribute

Retrieve table columns
Use the Web API query mentioned in Querying EntityMetadata columns to retrieve table columns. RetrieveAttributeRequest
UpdateAttribute

Update table columns
See Update tables UpdateAttributeRequest
UpdateStateValue

Update a label for a StateAttributeMetadata column
UpdateStateValue Action UpdateStateValueRequest

See also

Colum definitions
Create auto-number column