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 |
|
MTmace
Starting Member
7 Posts |
 Posted - 2006-12-12 : 18:35:16
|
| Is there a way to change the datatype of a column without dropping and recreating the whole table?MTmace |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-12 : 18:40:25
|
| Yes, you can use ALTER TABLE ALTER COLUMN.Tara Kizer |
 |
|
|
MTmace
Starting Member
7 Posts |
Posted - 2006-12-12 : 18:43:17
|
| Thanks, this is what I used.ALTER TABLE [Images] ALTER COLUMN [Width] realMTmace |
|
|
|
|
|
|
change datatype