All reserved words of every DBMS

database database-design reserved-words
bluish picture bluish · Dec 1, 2011 · Viewed 7.1k times · Source

I'm designing a database. Now it's on MySQL, but tomorrow could migrate on another DBMS. So I have to pay attention not to use reserved words (for MySQL and possibly for any other DBMS) as field names. And I don't want to use reserved word as field names, wrapped in quotes or square brackets!

Is there a site where I can find all reserved words for every DBMS? Or at least for the most used ones. It would be great if would exist a tool where you put a word and it gives you all DBMS for which it is a reserved word, if any.

If there is no online reference or tool of this kind, we could recollect a list of links for the pages of reserved words of every DBMS. Thanks a lot!

Answer

bluish picture bluish · Dec 1, 2011

WOW... I found this online tool: Reserved Word Search.

It's valid both for DBMS and programming languages. It seems quite up-to-date.

Related questions

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Read More
Database, Table and Column Naming Conventions?

Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: Should table names be plural? Should column names be singular? Should …

Read More
What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Read More