Quickly Dropping Columns

Question

Post reply

Quickly Dropping Columns

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
September 24, 2019 at 12:00 am

#3675279

Comments posted to this topic are about the item Quickly Dropping Columns

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Great question Steve. Really got the brain kick started this morning.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 2

glad you liked it. I'm trying to find some more interesting questions by trolling blog posts and forums

Thomas Franz Hall of Fame Points: 3893 More actions · Answer 3

I find the answers a little bit misleading. If a column is part of another index, FK or constraint, it just can't be dropped (without dropping / changing the index, FK / contraint before), since it throws an error message.

And dropping an index, FK / contraint is usually a metadata change too (rebuilding an index to remove the unwanted column is of course not an metadata operation).

God is real, unless declared integer.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 4

You should not be assuming this is part of anything else. If the question doesn't list it, it's not part of the scenario. This is a simple look at what a metadata operation is for a large table. If the item isn't referenced by another object, meaning it's not part of an index or other structure, it can be dropped.

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 5

Nice question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”