Re: Need SQL Reserved words list for DB/2, Ingress, MS-Access. Summary will be created.

In fact, there should NEVER be a need to know the reserved word list if the SQL system is ANSI compatible. ANSI says that they own all future words (not in those words of course) and that the only way for users to guarantee ANSI compatible SQL forever is to enclose their object names in double quotes. So:

   SELECT "SELECT" FROM "FROM" WHERE "WHERE" = "OVERTHERE" will always work properly. Some non-ANSI compliant systems will have problems cause they use single and double quotes interchangeably. They will have to be fixed sometime.

In article <DIC40u.Kz_at_actcom.co.il>, astea_at_actcom.co.il (Astea International) wrote:

> Dear netfriends,
>
> If you want to make your client-server application
> compatible to other DBMSs,
> avoiding using those reserved words is a good practice
> and will save a huge amout of work later.
>
> I need a list of all the SQL reserved works in DB/2, Ingres, and MS-Access.
>
> I already have the list of reserved words in Oracle, Sybase, Informix, and
> Watcom.
>
> When I get all lists, I'll summerize.
> Please help!
>
>
> Thanks in advance,
>
> Amnon
>
> *******************************************************
> *Astea Israel - Tefen Labs *
> * Email: astea_at_actcom.co.il *
> * Phone: (972) 4 - 987 2519 *
> * Fax: (972) 4 - 987 2031 *
> *When replying, please indicate the name of the *
> *addressee and the subject of your message! *
> *******************************************************
  Received on Wed Nov 22 1995 - 00:00:00 CET