| renaming a column [message #90085] |
Sat, 23 October 2004 22:07  |
sridhar
Messages: 119
Registered: December 2001
|
Senior Member |
|
|
hi all
anybody can help me about this problem
how to rename the column
regards
sridhar
|
|
|
|
| Re: renaming a column [message #90087 is a reply to message #90085] |
Sun, 24 October 2004 03:11  |
sachin sharma
Messages: 9
Registered: February 2004
|
Junior Member |
|
|
hi,
for example u hav a table called trial having two fields srno and name
u want to change the name of srno column to id_no then the code will be
alter table trial rename column srno to id_no;
hope this will solve ur problem
sachin sharma
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
