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

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.

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:


Spread the love

Leave a Reply

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