|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
change column name
how do you change the name of a column in an sql table? i know you use alter but is it like ALTER TABLE mytable CHANGE Blah TO Blah1 or what?
|
|
#2
|
|||
|
|||
|
Message Moved
Thread moved from 'PHP Coding' to 'Database Help' by sliver.
Reason: |
|
#3
|
|||
|
|||
|
RE: change column name
From the manual:
ALTER TABLE table_name CHANGE [COLUMN] old_col_name create_definition Obviously, create_definition is how you specified the column when you created the table, just with the new name. |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > change column name |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|