List of SQL reserved words/keywords
You can search and compare the reservation status of SQL standards and major DBs to check whether it is safe to use as a table name or column name.
Search
/You can move to the search field using the key. Example:SELECT, RETURNING, Tables
List of SQL reserved words
Select a row to see treatment by DB and safe citation examples.
Showing 0 items
| meaning |
|---|
There are no keywords matching your criteria.
SELECT
Reservation status by DB
identifier check
Enter table and column names and check for conflicts with reserved words and example citations.
Compare between DBs
Compare how the same keyword is handled by each DB.
| Comparison items | Left | Right |
|---|
About this tool
Before using SQL reserved words or DB-specific keywords in object names, you can check how they are handled in the target DB and how to quote them.
Features
- SQL standard, Oracle, PostgreSQL, MySQL, SQL Server, SQLite
- Filter by reservation status, purpose, and initial letter
- Identifier check, comparison between DBs, copy of citation examples
Notes
- Reserved words may vary by DB version and operating mode.
- Avoiding names that are the same as reserved words improves portability, even if they can be quoted.
- Please also check the official documentation for the version you are using when making your final decision.