Delete Button Missing in SharePoint Column? Here is How to Delete it!

How to delete a Column from SharePoint List when Delete Button is missing?

Unable to delete list column in SharePoint since there is no delete button in field properties? In some cases, columns added through “Add existing columns” don’t provide the option to delete! To make them deletable, revert these two properties: AllowDeletion & Sealed.
sharepoint column no delete button - sharepoint list sealed and non-deletable columns

Delete a column from SharePoint List using PowerShell

Here is how to delete the SharePoint list column programmatically with PowerShell: 

#Get the Web
$web = Get-SPWeb ""

#Get the List
$list = $web.Lists["Design Documents"]

#Get the column
$column = $list.Fields["Category"]

#Disable Delete
$column.AllowDeletion = $true
$column.Sealed = $false

#delete a SharePoint list column in PowerShell


sharepoint column delete button missing
We can also make fields Sealed So that nobody can change the field settings.

SharePoint Manager tool can be used to set these properties. Navigate to the site, list, or library and set the “AllowDeletion” property to false, save the changes. This hides the delete option in the SharePoint list.
sharepoint list column enable disable delete option

Here is another post to make a non-deletable column: How to Prevent SharePoint List or Columns from Deletion?

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *