SQL Drop Column - ALTER TABLE DROP COLUMN failed because one or more objects access this column
Posted on 2014-11-17
I'm testing some code which, among other things, adds columns to some tables. When I want to run it again to test it, I keep having to go into Design and delete the columns manually, which is a pain,
I've tried using Drop Column but can't as per my question title. None of these columns are indexed, so I can only assume that it's because they get used later on in the code. Part of the code is to create them (which I will have to do when I run it live). Is there any way around this?
I'm awarding 500 points for a quick and working solution.