In this blog post, let’s learn about the error message “328 Column column-name already exists in table.” in Hydra and the description of the error.
Error Message
328 Column column-name already exists in table.
Error Details
This statement tries to add the column shown, but one with that name already exists. Check the spelling of the name; if it is as you intended, then the table is not arranged as you expected it to be. You can review the names of all the columns in a table by querying syscolumns. Supply a table-name in the following query:
SELECT colname, colno FROM syscolumns C, systables T WHERE C.tabid = T.tabid AND T.tabname = ‘table-name’
You can use RENAME COLUMN to change column names.