ALTER -- problems
Posted: Mon Jul 05, 2004 7:08 pm
I need to alter the properties of a column, and make the values within both UNIQUE and KEY.
from what i have gathered so far...
ALTER TABLE `table_name` CHANGE `initial_column_name` `new_column_name` VARCHAR( 30 ) (other values...where i need to set UNIQUE and PRIMAEY KEY)
I don't know if i am writting the architecture of the code wrong or any other problem, but I was wondering if someone could type out and example for me to see that might clarify where / what I am doing wrong.
Thnx
from what i have gathered so far...
ALTER TABLE `table_name` CHANGE `initial_column_name` `new_column_name` VARCHAR( 30 ) (other values...where i need to set UNIQUE and PRIMAEY KEY)
I don't know if i am writting the architecture of the code wrong or any other problem, but I was wondering if someone could type out and example for me to see that might clarify where / what I am doing wrong.
Thnx