list of ALL keywords by database

Thread view:

timasmith@hotmail.com - 11 Jun 2006 13:08 GMT

What would be useful is an URL to a list of all keywords for
Oracle
mySQL
SQLServer
MS Access
HSql

etc.

Then I could keep the keywords out of the table and columns names in my
schema...

Any such list that you know of?

thanks

Tim

Reply to this Message

David Harper - 11 Jun 2006 15:08 GMT

> What would be useful is an URL to a list of all keywords for
> Oracle
[quoted text clipped - 9 lines]
>
> Any such list that you know of?

DatabaseMetaData.getSQLKeywords will return a list of all of the
database's keywords that are not SQL92 keywords.

So now all you need is a list of SQL92 keywords, and a call to
getSQLKeywords fills in the database-specific extras.

David Harper
Cambridge, England

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...