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 |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2005-06-20 : 03:36:02
|
| Hello, Is there any way i can set the Column Property to null using the scripts. Autogenerated scripts, create the temp table and inserts all the value into the that temp table from the master table and then its drop the master table and then again creates it,with the column property to null and then insert back the data into it. is there any other simpler method then this ?ThanksComplicated things can be done by simple thinking |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-20 : 03:41:08
|
| Alter table to set that column to NullLook for Alter table in BOLMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Setting Column To Null