pf » Updated SQL Reserved Words Checker

March 28, 2006

Updated SQL Reserved Words Checker

I just updated my SQL reserved words checker to include a few new words from MySQL 5 that it wasn't picking up.

I use the tool when I'm designing a database table, or column. It can tell you if a value is a reserved word in MySQL, PostgreSQL, Oracle, or SQL Server.

Permalink | Add Comment |

add to del.icio.us | Tags: sql, reserved, databases, mysql

Related Entries

Sphinx - Open Source SQL Full Text Search Engine - November 1, 2006
MySQL FULLTEXT Indexing and Searching - September 29, 2005
SQL to Select a random row from a database table - September 14, 2005
Insert Delayed with MySQL - August 2, 2005
Multiple Inserts with MySQL - June 10, 2005

8 people found this page useful, what do you think?

Trackbacks

Trackback Address: 553/EFD34086B48E2B7D709431ABCC8058B9

Comments

On 03/29/2006 at 3:26:52 AM MST Fredrik wrote:

Why don't you add support for SQL-92, SQL-99, and SQL-2003 as well? You can find a table with reserved words in SQL-xxx at http://developer.mimer.com/validator/sql-reserved-words.tml. /Fredrik

On 03/29/2006 at 5:03:57 AM MST Richard wrote:

Hi, I've just checked 'BEFORE' in your reserved word checker and it shows as not reserved in MySQL whereas it actually became a reserved word in ver 4.1. Is it me or have you missed it? Cheers, Richard.

On 01/07/2008 at 11:53:43 AM MST Kathy wrote:

Nice tool.

I suggest you allow the entry of multiple words at one (comma or space delimited).