renaming my sql columns

[bastien]

I need to rename some columns in a db...

I have tried

ALTER tester CHANGE  COLUMN  'Blah' 'blah'

with no luck

any idea?

[DonChris]

change

ALTER tester CHANGE COLUMN 'Blah' 'blah'

to
ALTER TABLE tester CHANGE COLUMN Blah blah varchar(10)...

drop quotes and add column-definition

hth chris

[bastien]

works...thanks