如何在IntelliJ中设置SQL方言 [英] How to set sql dialect in IntelliJ

问题描述

我正在使用IntelliJ2017.我想为sql文件设置SQL方言.创建文件后，顶部会显示一条消息，说明未设置文件的SQL方言.当我单击将方言更改为.."链接时，它将打开一个SQL方言菜单.在右侧，有一个下拉链接用于选择方言，但下拉菜单为空.我进入首选项">语言和框架">"SQL方言"以尝试添加一些内容，但是该菜单还是空的，我似乎无法修改任何字段.

I'm working with IntelliJ 2017. I want to set the SQL dialect for an sql file. After I created the file, there is a message at the top saying the SQL dialect for the file is not set. When I click on the "Change Dialect to.." link, it opens an SQL Dialects menu. On the right, there is a pulldown link to select the dialect, but the pull down menu is empty. I went into Preferences > Languages and Frameworks > SQL Dialects to try to add some, but that menu is also empty and I can't seem to modify any of the fields.

如何将SQL方言添加到IntelliJ，以便可以为此文件选择一个?下面是在sql文件中选择将方言更改为..."时得到的菜单的照片

How do I add SQL dialects to IntelliJ, so I can select one for this file? Below is a photo of the menu I get when I select "Change Dialect to..." in the sql file

下面是我从"Perferences">语言和框架">"SQL方言"中获得的菜单的照片.我无法编辑任何字段.

Below is a photo of the menu I get from Perferences > Languages and Frameworks > SQL Dialects. I can't edit any of the fields.

推荐答案

请检查是否启用了"数据库工具和SQL "插件.

Please check if "Database tools and SQL" plugin is enabled.

Settings或Preferences> Languages & Frameworks> SQL Dialects

这是我的IDE中的外观:(2018.2 EAP)

Here is how it looks in my IDE: (2018.2 EAP)

这篇关于如何在IntelliJ中设置SQL方言的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！