Re: list of ALL keywords by database

From: David Harper <devnull@xxxxxxxxxxxxxxxxxxx>
Date: Sun, 11 Jun 2006 14:08:23 GMT

timasmith@xxxxxxxxxxx wrote:

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?

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
.

References:
- list of ALL keywords by database
  - From: timasmith

Prev by Date: list of ALL keywords by database
Next by Date: Database ODBC
Previous by thread: list of ALL keywords by database
Next by thread: Database ODBC
Index(es):
- Date
- Thread

Relevant Pages

Re: Adding command to a text file to make a sql statement?
... upload it to Mysql. ... Assuming that's a tab character between the ID and the keywords: ... The newline character doesn't work as expected. ...
(comp.unix.shell)
Re: [PHP] Mysql strategy
... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... and the machine is a dedicated server running RHEL. ... solution of MySQL, only yours is a lot slower... ...
(php.general)
Re: Trouble escaping / Misc nightmare
... :>'Group' is an invalid name for a column! ... : LOL. ... Apparently mysql can escape keywords using `keyword`. ...
(comp.lang.php)
Adding command to a text file to make a sql statement?
... The first column ... displays a number and the second column displays some ... ID keywords ... upload it to Mysql. ...
(comp.unix.shell)
Re: Adding command to a text file to make a sql statement?
... displays a number and the second column displays some ... ID keywords ... upload it to Mysql. ... Assuming that's a tab character between the ID and the keywords: ...
(comp.unix.shell)