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 |
|
anuradhay
Starting Member
41 Posts |
 Posted - 2004-12-20 : 22:34:50
|
| Hi,I have created a table with ansi_padding on. Now i want to change the option to off. can i do this without droping the table and creating it again. can i use alter stmt or something like that..?Thanks, |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-21 : 14:12:42
|
| While there is an ANSI Padding value in the syscolumns table, I would recommend using the drop and recreate approach.HTH=================================================================The best things in life are nearest: Breath in your nostrils, light in your eyes, flowers at your feet, duties at your hand, the path of right just before you. -Robert Louis Stevenson, novelist, essayist, and poet(1850-1894) |
 |
|
|
|
|
|
Ansi_padding