How can I use a reserved keyword as a common field?

Database
Enthusiast

How can I use a reserved keyword as a common field?

Hi!

I have one table that has a filed called "" and RELEASE is reserved key
word.

That is my query:

SELECT , FIELD1 FROM TABLE1 ORDER BY

It doesn't function so How can I use a reseved keyword as a common field?

Thanks for help,
Anderson
2 REPLIES
Teradata Employee

Re: How can I use a reserved keyword as a common field?

Use quoted identifier syntax:

SELECT "RELEASE", FIELD1 FROM TABLE1;
Enthusiast

Re: How can I use a reserved keyword as a common field?

Thank you so much for help!