sql - Syntax error when selecting column 'Comment' in Sybase IQ -
i have table columns in sybase iq. 1 of columns named "comment".
whenever select column:
select comment i got error:
[error code: 102, sql state: 42w04] sql anywhere error -131: syntax error near 'comment' i able select other columns without issues. advise reason , solution? thank you
try
select "comment" comment reserved word in sybase iq.
here the link explaining problem.
some keywords in sql reserved words. use reserved word in sql statement identifier, must enclose word in double quotes. many, not all, of keywords appear in sql statements reserved words. example, must use following syntax retrieve contents of table named select.
select * "select"
Comments
Post a Comment