跳转到主要内容
Develop Tools

SQL 保留字・关键字列表

搜索和比较 Oracle、PostgreSQL、MySQL、SQL Server、SQLite 及 SQL 标准的保留字和关键字,并确认能否用作标识符。

Search

/You can move to the search field using the key. Example:SELECTRETURNING

List of SQL reserved words

Select a row to see treatment by DB and safe citation examples.

Showing 0 items

meaning

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

Additional information: DB

Additional information for this feature. 左侧 右侧

关于此工具

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.

支持的功能

  • SQL standard, Oracle, PostgreSQL, MySQL, SQL Server, SQLite
  • Additional information for this feature.
  • Identifier check, comparison between DBs, copy of citation examples

Additional information for this feature.

  • Additional information: DB
  • 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.

关于此工具

You can check whether a word is a reserved word for each database at once when naming table or column names, migrating SQL, or investigating syntax errors.

支持的功能

  • Search, classify, and compare SQL standards, Oracle, PostgreSQL, MySQL, SQL Server, and SQLite
  • Identifier reserved word determination, generation and copying of quoted identifiers that match the database

使用方法

  1. Narrow down your suggestions by specifying search terms, databases, classifications, and categories.
  2. Select
  3. Enter the name into the identifier check and copy the quoted notation if necessary.

限制事项

  • Additional information for this feature.
  • The content listed is a practical list of major reserved words and keywords, and does not include a complete list of all keywords for each product.

隐私: Search, comparison, identifier determination, and copying are performed within the browser, and input contents are not sent or saved to the Develop Tools server.