ReSharper by Language: SQL and NoSQL
This section contains information about ReSharper features in SQL-like files and SQL injections in C# strings.
Depending on the databases you work with, you may have SQL files in different dialects (DBMS-specific versions of SQL) in your solution. To make sure that syntax highlighting, code completion, and code inspection work correctly in each SQL file, you need to configure the SQL dialects.
Configure SQL dialects
Select from the main menu or press Alt+R O, then choose on the left.
Use the Solution SQL Dialect selector to choose the dialect that is predominantly used in your solution.
If the solution has SQL files in other dialects, add those files or folders that contain those files to the Custom SQL dialects table, and specify the corresponding dialects for them.
Alternatively, you can change the dialect of an SQL file from the editor, using the selector at the bottom:
In addition to that, ReSharper will display a warning if neither solution SQL dialect nor the dialect for the current file is specified in options:
You can disable this warning on the page of ReSharper options Alt+R, O by clearing the Show a warning when SQL dialect is not specified in the current file checkbox.
Supported SQL dialects
ReSharper supports the following SQL and NoSQL dialects:
Amazon Redshift
Apache Cassandra
Apache Derby
Apache Hive
Apache Spark
Azure SQL Database
BigQuery
ClickHouse
CockroachDB
Couchbase Query
DynamoDB
Exasol
Generic SQL
Greenplum
H2
HSQLDB
IBM Db2 iSeries
IBM Db2 LUW
IBM Db2 z/OS
MariaDB
Microsoft SQL Server
MongoDB
MySQL
Oracle
Oracle SQL*Plus
PostgreSQL
Redis
Snowflake
SQLite
SQL2016
Sybase ASE
Vertica