Sql Anywhere 16, unable to add comment an existing table

[former_SQLA_member1694965]

Hello, Im trying to add the add as follows:

ALTER TABLE dbo.api_sugar_uggroups ADD Comment TEXT NULL

but return the erros: syntax error near 'Comment' on line 1 SQLCODE=-131, ODBC 3 state="4200" line 1, column 1

So, Im not sure how to fix it.

Jorge Santos

[VolkerBarth · Accepted solution]

You are using ALTER TABLE to add a column to the according table. If that is what you want, note that COMMENT is a reserved word and needs to be put in double quotes when used as a column name or other identifier, so you should try:

ALTER TABLE dbo.api_sugar_uggroups ADD "Comment" TEXT NULL

However, if you just want to add a comment on the table, use the separate COMMENT statement instead.

[former_SQLA_member1694965 · Accepted solution]

Dear Volker,

I double quoted and now it's ok. Thank you very much for your help.

Jorge Santos