ALTER TABLE changing column name

Question

When using ALTER TABLE to modify the column name in a table, we need to define the data type again:

ALTER TABLE tabela CHANGE COLUMN nome_antigo novo_nome tipo_dados;

If the data type is not defined, a syntax error. Every time we change the name of a column it is also necessary to declare the type of data or there is another simpler way?

Answer 1

Actually to change only the correct name is :

ALTER TABLE tabela RENAME COLUMN nome_antigo TO novo_nome;

I put in the Github for future reference.