Change column heading in table

melgra70 · #1 (**permalink**) 03-14-11, 05:30

I need to change the name of a column in one of my tables.
The table is “judge”
The column is “Address” which needs to change to “Suburb”.

I’ve looked for answers and come up with:

alter table judge change address to ‘Suburb’;

The syntax error indicates it is near ‘to ‘Suburb’’; I’m not even sure I’m using the correct statement. Can you help, please?

it-iss.com · #2 (**permalink**) 03-14-11, 06:03

This is almost correct. When renaming a column you also need to provide the data type.

Code:

ALTER TABLE judge CHANGE Address Suburb VARCHAR(100);

Internet Services

Web Development

Digital Marketing

Consumer Tech