Notion Database Cannot Delete Property: Workaround

You may encounter a situation where the delete option is grayed out or missing when you try to remove a property from a Notion database. This typically happens because the property is being referenced elsewhere, such as in a formula, a relation, a rollup, a template default, or a linked database view. Notion prevents deletion of properties that are still in use to avoid breaking database functionality. This article explains the exact reasons a property becomes undeletable and provides a step-by-step workaround to remove it safely.

Why a Notion Database Property Cannot Be Deleted

Notion enforces referential integrity within databases. A property that is actively used by another property, a template, or a view cannot be removed because doing so would break the dependent elements. The most common causes include:

Dependencies From Formulas and Rollups

If any formula or rollup property references the property you want to delete, Notion blocks the deletion. For example, a formula that uses prop("Price") prevents the “Price” property from being deleted. The same applies to rollups that pull data from a relation property.

Relation Properties Connected to Other Databases

A relation property creates a two-way link between two databases. Deleting the relation property requires removing the connection from both sides. If the other database still references the relation, deletion is blocked.

Template Defaults Containing the Property

Database templates can include property values. If a template has a default value set for the property you are trying to delete, the delete action is disabled. The property must be removed from every template first.

Linked Database Views Referencing the Property

A linked view of the database may include the property in its visible columns or filters. Even if you are working in the original database, the link prevents deletion. You must edit the linked view to remove the property.

Steps to Delete a Locked Database Property

Follow these steps in order. After each step, check whether the delete option becomes available. Repeat the process for each database that has the same issue.

Step 1: Remove Property References From All Formulas

1. Open the database
   Navigate to the database that contains the locked property. Click anywhere inside the database to select it.
2. Find all formula properties
   Look at the property header row. Identify every column that has a formula icon (fx). Click the property name and select Edit property to open the formula editor.
3. Remove references to the target property
   In each formula, delete any line that calls prop("PropertyName") where PropertyName is the locked property. Replace the formula with a static value or a different property. Click Done to save.
4. Check all rollup properties
   Rollup properties also reference a relation property. If the locked property is a relation, open each rollup and change the Property dropdown to a different property or remove the rollup entirely.

Step 2: Remove Property References From All Rollups

1. Identify rollup properties
   Scroll through the property headers. Rollup properties show a sigma icon (Σ). Click the property name and choose Edit property.
2. Change the relation property
   In the Relation dropdown, select a different relation property that does not involve the locked property. If no alternative relation exists, delete the rollup property entirely by clicking Delete in the property menu.

Step 3: Remove Property From All Database Templates

1. Open the database templates
   Click the downward arrow next to New at the top of the database. Select + New template or click an existing template name from the list.
2. Edit each template
   For each template, scroll through the template page. Locate the property that matches the locked property name. Click the property value and press Delete or Backspace to clear it. If the property shows as a block on the template page, delete that block by clicking the six-dot handle and choosing Delete.
3. Save the template
   Click Back to return to the database. Repeat for all templates.

Step 4: Remove Property From All Linked Database Views

1. Find linked views
   Look for any page that contains a linked database block. These blocks show the original database name with a chain link icon. Click the linked view to select it.
2. Edit the linked view properties
   Click the property header of the locked property in the linked view. Select Hide or Remove from view. This does not delete the property from the source database but breaks the dependency.
3. Remove from filters and sorts
   Click the Filter or Sort button at the top of the linked view. Delete any filter or sort condition that uses the locked property. Click Done to apply.

Step 5: Delete the Property

1. Return to the original database
   Navigate back to the database where the property is locked. Hover over the property header and click the downward arrow that appears.
2. Select Delete
   If the option is no longer grayed out, click Delete. Confirm the deletion in the pop-up dialog. The property is removed from all pages in the database.

If Notion Still Blocks Deletion After the Main Fix

Property Is Still Referenced in a Formula or Rollup

Double-check every formula and rollup. A single overlooked reference will keep the delete option disabled. Use the Find feature (Ctrl+F) in the database to search for the property name inside formula blocks. This is faster than opening each property editor manually.

Template Has a Default Value for the Property

Notion templates can inherit properties from the database. Even if you cleared the value, the property block may still exist. Delete the entire property block from the template page. To confirm, open the template and look for any block that shows the property name and a value field. Remove it completely.

Linked View Exists in a Different Workspace

If the database is shared across workspaces, a linked view in another workspace may reference the property. Ask the workspace owner to remove the property from the linked view. Alternatively, duplicate the database and delete the property in the duplicate to avoid cross-workspace issues.

Database Is Locked or Read-Only

Check whether the database has been locked by a workspace admin. Go to the three-dot menu at the top of the database page and look for Lock database. If it is enabled, disable it first. Read-only permissions also block property deletion. Ensure your user role has Can edit access.

Notion Database Property Deletion: Common Causes and Solutions

Cause	What to Check	Solution
Formula references the property	All formula properties in the database	Edit each formula to remove prop("PropertyName")
Rollup uses the property	Rollup properties that depend on a relation	Change the relation dropdown or delete the rollup
Template contains the property	All templates in the database	Delete the property block from each template page
Linked view shows the property	Pages with linked database blocks	Hide the property and remove it from filters and sorts
Relation property is connected	The related database on the other side	Remove the relation property from the other database first

After following the workaround steps, you can successfully delete the locked property. To prevent this issue in the future, use the Hide option instead of deletion when you only need to remove a property from view. Hiding a property does not require removing references and keeps the database structure intact. If you frequently encounter locked properties, audit your database formulas and templates before making structural changes.