[GRASS5] dropping or renaming a column

[Kirk R. Wythers]

On Apr 27, 2005, at 11:11 AM, Jachym Cepicky wrote:

> for adding columns to the table see manual of db.execute
>
>     echo "alter table vector_file add column column_name 
> varchar(50)"|db.execute
>

Thanks!

How about removing a column or changing a column name? I've tried:

 > echo "ALTER TABLE table_name DROP COLUMN column_name double" | 
db.execute

and

  > echo "ALTER TABLE table_name CHANGE COLUMN old_column_name 
new_column_name double" | db.execute

with no success...

Kirk