historic construction of post office in new york city
Databases, SQL, Stored Procedures

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

Spread the love

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.


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.


Spread the love

Leave a Reply

Your email address will not be published.