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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-04-21 : 05:02:14
|
| How can we changer column name by useing Sql query only |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 05:03:56
|
sp_rename.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-04-21 : 05:11:14
|
| please give example |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 05:16:14
|
First read Books Online about sp_rename stored procedure.Then, if you still don't understand, we can give examples.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-21 : 05:27:00
|
quote:
Originally posted by boreddy
please give example
or do google search on sp_rename+sql serverMadhivananFailing to plan is Planning to fail |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-04-21 : 05:57:38
|
| ok I got the Solution is it possible to do by useing alter comand |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-21 : 06:04:54
|
What does Books Online tell you?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
How can we changer column name