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

How to delete a Column 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" doesn't provide the option to delete! To make them deletable, just revert these two properties: AllowDeletion & Sealed
sharepoint column no delete button - sharepoint list sealed and non-deletable columns
Here is how to delete 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

#To delete a SharePoint list column in PowerShell, use: $column.Delete() 

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

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

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

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.