var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Change column heading in table
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?
This is almost correct. When renaming a column you also need to provide the data type.
ALTER TABLE judge CHANGE Address Suburb VARCHAR(100);