Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2011-02-16 : 11:01:09
|
| Hello,I have a table Books with some data and one of the columns (Resume) is no longer needed. I want to discard all the content in it in all records.The column is a simple nvarchar(400). No relations there. No restriction.What is the best way to delete that column?Thank You,Miguel |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-16 : 11:57:17
|
| update booksset resume=nullor if you want to permananrly remove the columnalter table booksdrop column resumeMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Delete column