View Single Post

  #4 (permalink)  
Old 04-25-2007, 10:46 AM
cyrus cyrus is offline
Senior Member
 
Join Date: Apr 2006
Posts: 153
cyrus is on a distinguished road
You can rename a column in a table as follows:

ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;

I would suggest that you must be careful and assured while designing the database itself regarding these. Only if it is very essential go for this process now.
Reply With Quote