How to ALTER a Column using ADS SQL

[rdonnay]

The Advantage documentation for ALTER TABLE ALTER COLUMN is terrible.

I want to use SQL to change a field name but cannot figure out a syntax that works.

We have a lot of fields in a lot of tables that need to be changed from USER to USR.

Any ideas?

[rdonnay]

It took a while to figure out that the column names must be quoted. I had to look in my SqlQuery.prg code to see how I did it 2 years ago.

I forgot.

This is correct syntax:

ALTER TABLE mn_drv
ALTER COLUMN "user" "usr" char(10)

[Tom]

The Advantage documentation for ALTER TABLE ALTER COLUMN is terrible.

This is true for the complete documentation.