Use SQL to drop a column, if it exists in a table

05 Apr 2016 Databases, SQL, Stored Procedures No Comments

I recently needed to write a script for a customer to run against their database, to delete a column from a table. I wanted to make sure it would only run if that column existed, especially as the column had originally been created by a script that failed to complete and would now not run because of the column’s existence!

After a little Googling I put two resources together to come up with the following solution and test set-up.

Solution

When running this code a second time it will still run, but there are no changes or errors.

Test Set-up

Run this first to test the above solution.

Resources: