How To Delete A Column In SharePoint List

Deleting a column in SharePoint List is a simple process that can be done using either the SharePoint Web UI or PowerShell. By removing unnecessary columns, you can improve workplace efficiency and streamline your SharePoint list.

If you prefer using the SharePoint Web UI, you can easily delete a column by following these step-by-step instructions. Simply browse to the List or Library, click on the List or Library tab, go to List Settings / Library Settings, click on the column name, scroll down, and click on the “Delete” button.

In case the Web UI method doesn’t meet your requirements or if you prefer a more advanced and flexible option, you can utilize PowerShell. The provided PowerShell script example demonstrates how to delete a column from a SharePoint list. By executing the script, you can efficiently manage your SharePoint lists and their columns.

It is crucial to keep in mind that when you delete a column in SharePoint, all the data within that column will also be deleted. Therefore, it is highly recommended to back up your data before proceeding with any deletions to prevent any unintended data loss.

Deleting columns in SharePoint List doesn’t have to be complicated. With the SharePoint Web UI or PowerShell, you can effortlessly remove unnecessary columns and enhance your overall efficiency. Remember to always back up your data and exercise caution when making changes to your SharePoint lists.

Deleting a Column Using SharePoint Web UI

To delete a column using the SharePoint Web UI, you need to access the List or Library settings and navigate to the specific column you want to delete. Here is a step-by-step guide:

  1. First, browse to the List or Library where the column is located.
  2. Click on the List or Library tab, which can be found at the top ribbon of the page.
  3. In the Settings section, click on “List Settings” or “Library Settings”.
  4. Scroll down to the Columns section, where you will find a list of all the columns in your SharePoint list.
  5. Locate the column you want to delete and click on its name to open its settings.
  6. At the bottom of the column settings page, you will find the “Delete” button. Click on it to delete the column.

By following these simple steps, you can easily delete a column in your SharePoint list using the Web UI, without the need for any coding or scripting knowledge.

Example:

Let’s say you have a SharePoint list called “Change Request” and you want to delete the column named “Activity Status”. To accomplish this, follow the steps mentioned above and locate the “Activity Status” column in the List Settings. Click on its name and then click on the “Delete” button at the bottom of the column settings page. The column will be permanently deleted from your SharePoint list.

Important Note:

When you delete a column in SharePoint using the Web UI, please keep in mind that all the data stored in that column will also be permanently deleted. To avoid any unintended data loss, it is highly recommended to back up your data before deleting any columns.

Summary:

In this section, we discussed how to delete a column in a SharePoint list using the SharePoint Web UI. We provided step-by-step instructions to guide you through the process, ensuring that you can easily remove unnecessary columns from your SharePoint list without any coding or scripting knowledge. Remember to always back up your data before deleting any columns to avoid unintended data loss.

Deleting a Column Using PowerShell

PowerShell is a powerful tool that allows you to automate the management of SharePoint lists, including deleting columns. Here is an example PowerShell script that you can use to delete a column from a SharePoint list:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$SiteURL = “https://intranet.crescent.com/”

$ListName = “Change Request”

$ColumnName = “Activity Status”

$web = Get-SPWeb $SiteURL

$list = $web.Lists.TryGetList($ListName)

if ($list -ne $null) {

$column = $list.Fields[$ColumnName]

if ($column -ne $null) {

$column.Hidden = $false

$column.ReadOnlyField = $false

$column.AllowDeletion = $true

$column.Update()

$list.Fields.Delete($column)

Write-Host “Column has been deleted!” -f Green

} else {

Write-Host “Specified column name not found!” -ForegroundColor Red

}

}

You can also create a custom function to delete columns from a SharePoint list using PowerShell, for bulk deletion of columns.

It is important to note that when you delete a column in SharePoint, all the data in that column is also deleted, so make sure to back up your data before deleting any columns.

Summary

  • PowerShell is a powerful tool for managing SharePoint lists, including deleting columns.
  • The provided PowerShell script demonstrates how to delete a column from a SharePoint list.
  • Remember to backup your data before deleting any columns in SharePoint.

Important Considerations When Deleting Columns in SharePoint

Before you proceed with deleting a column in SharePoint, there are important considerations to keep in mind. Deleting a column can result in unintended consequences or data loss if not executed carefully. Here are some important guidelines to follow:

  • Back up your data: Prior to deleting any column, it is crucial to create a backup of your SharePoint list to ensure that no data is lost. This backup will serve as a safety net in case you need to retrieve any deleted information.
  • Communicate with stakeholders: If the column you are deleting contains important information or is used by other team members, it is essential to communicate with them beforehand. This will help avoid any disruptions or loss of data that may impact their work.
  • Review dependencies: Check if the column you want to delete is linked to any workflows, forms, or other lists. Deleting a column without considering these dependencies can lead to errors and data inconsistencies.
  • Test in a non-production environment: Before performing the deletion in a live SharePoint environment, it is recommended to test the process in a non-production environment. This will help you identify any potential issues or ensure that the deletion process works as expected.

By following these considerations, you can safely delete columns in SharePoint without jeopardizing your data or workflow.

Summary

  • Deleting a column in SharePoint requires careful consideration to avoid data loss or disruptions.
  • Backup your data, communicate with stakeholders, review dependencies, and test in a non-production environment.
  • Following these guidelines will help ensure a smooth and safe column deletion process in SharePoint.
Column Name Data Type Description
Title Single line of text The default column in SharePoint lists used to store the title or name of each item.
Created By Person or Group Automatically tracks the user who created the item.
Modified By Person or Group Automatically tracks the user who last modified the item.

Important Considerations When Deleting Columns in SharePoint

When deleting a column in SharePoint, it’s important to remember that all the data stored in that column will also be permanently deleted. Therefore, it is strongly recommended to back up your data before proceeding with any column deletion.

Backing up your data ensures that you have a copy of the information stored in the column, in case you need to access it in the future. It is a precautionary measure to prevent any unintended data loss. SharePoint provides several methods to back up your data, such as using the built-in backup features or exporting the list to a spreadsheet or database.

Additionally, it is crucial to communicate with your team or colleagues about the column deletion. Inform them about the upcoming changes and the potential impact it might have on their work or any connected processes. This proactive approach can help minimize any disruption and ensure a smooth transition.

Lastly, before deleting a column, thoroughly review the data stored in it. Identify any critical information or dependencies on other columns or workflows. This step will help you gauge the impact of the deletion and make any necessary adjustments or preparations beforehand.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.