Update database properties

Deprecated as of version 2025-09-03This page describes the API for versions up to and including 2022-06-28. In the new 2025-09-03 version, the concepts of databases and data sources were split up, as described in Upgrading to 2025-09-03.Refer to the new page instead:

Update data source properties

The API represents columns of a database in the Notion UI as database properties. To use the API to update a data source’s properties, send a PATCH request with a properties body param.

Remove a property

To remove a database property, set the property object to null.

"properties": {
  "J@cT": null,
}

"properties": {
  "propertyToDelete": null
}

Rename a property

To change the name of a database property, indicate the new name in the name property object value.

"properties": {
	"J@cT": {
		"name": "New Property Name"
  }
}

"properties": {
  "Old Property Name": {
    "name": "New Property Name
  }
}

Property	Type	Description
`name`	`string`	The name of the property as it appears in Notion.

Update property type

To update the property type, the property schema object should contain the key of the type. This type contains behavior of this property. Possible values of this key are "title", "rich_text", "number", "select", "multi_select", "status", "date", "people", "files", "checkbox", "url", "email", "phone_number", "formula", "relation", "rollup", "created_time", "created_by", "last_edited_time", "last_edited_by". Within this property, the configuration is a property schema object.

LimitationsNote that the property type of the title cannot be changed.

Select configuration updates

To update an existing select configuration, the property schema object optionally contains the following configuration within the select property:

Property	Type	Description	Example value
`options`	optional array of existing select options and select option objects	Settings for select properties. If an existing option is omitted, it will be removed from the database property. New options will be added to the database property.

Existing select options

Note that the name and color of an existing option cannot be updated.

Property	Type	Description	Example value
`name`	optional `string`	Name of the option.	`"Fruit"`
`id`	optional `string`	ID of the option.	`"ff8e9269-9579-47f7-8f6e-83a84716863c"`

Multi-select configuration updates

To update an existing select configuration, the property schema object optionally contains the following configuration within the multi_select property:

Property	Type	Description	Example value
`options`	optional array of existing select options and multi-select option objects	Settings for multi select properties. If an existing option is omitted, it will be removed from the database property. New options will be added to the database property.

Existing multi-select options

Note that the name and color of an existing option cannot be updated.

Property	Type	Description	Example value
`name`	`string`	Name of the option as it appears in Notion.	`"Fruit"`
`id`	optional `string`	ID of the option.	`"ff8e9269-9579-47f7-8f6e-83a84716863c"`

Status configuration updates

To update an existing status configuration, the property schema object optionally contains the following configuration within the status property:

Property	Type	Description	Example value
`options`	optional array of existing status options and status option objects	Settings for status properties. If an existing option is omitted, it will be removed from the database property. New options will be added to the database property and assigned to the requested group when provided.

Existing status options

Note that the name and color of an existing option cannot be updated. Use group to assign an existing or new option to one of the existing status groups.

Property	Type	Description	Example value
`name`	optional `string`	Name of the option as it appears in Notion.	`"In review"`
`id`	optional `string`	ID of the option.	`"ff8e9269-9579-47f7-8f6e-83a84716863c"`
`group`	optional `string` (enum)	Status group to assign the option to. Possible values are `To-do`, `In progress`, and `Complete`. Existing options keep their current group when omitted. New options use `To-do` when present, or the first existing group otherwise.	`"In progress"`

Limitations

Reading computed formula and rollup property values has its own limitations, such as values that are too complex to compute.

Notion API

Objects

Endpoints

Webhook events

Update database properties

Remove a property

Rename a property

Update property type

Select configuration updates

Existing select options

Multi-select configuration updates

Existing multi-select options

Status configuration updates

Existing status options

Limitations

​Remove a property

​Rename a property

​Update property type

​Select configuration updates

​Existing select options

​Multi-select configuration updates

​Existing multi-select options

​Status configuration updates

​Existing status options

​Limitations

Remove a property

Rename a property

Update property type

Select configuration updates

Existing select options

Multi-select configuration updates

Existing multi-select options

Status configuration updates

Existing status options

Limitations