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 |
|
saivyshnav
Starting Member
17 Posts |
 Posted - 2006-12-04 : 14:10:01
|
| Hi allALTER TABLE <Table_Name> ALTER COLUMN <column_name> <Data_type>above query alters the sigle column but how to alter multiple columns at timesaivyshnavJunior DBA |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-04 : 14:16:51
|
| I create a new temporary table with the appropriate column definitions, cop the data over, drop the original, rename the Temporary to become the Master table.You can use Enterprise Manger's "Table design" which will do all the necessary steps "behind the scenes"Kristen |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-04 : 14:20:59
|
| I can't SNIPE you AFTER you've posted .... Sheesh! |
|
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2006-12-05 : 05:59:20
|
| Hi saiIt is not possible seemsyou try column by columnSreenivasaRaoBangalore,INDIA |
|
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2006-12-05 : 06:02:29
|
| Hi saifallow the Kristen suggestion or do column by column alterI create a new temporary table with the appropriate column definitions, cop the data over, drop the original, rename the Temporary to become the Master table.You can use Enterprise Manger's "Table design" which will do all the necessary steps "behind the scenes"SreenivasaRaoBangalore,INDIA |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-05 : 10:50:45
|
that's probably the first time that happened. by the milisecond...sheesh...Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
how to alter multiple columns at time
Look at that