To work with files from your machine or any other place you have access to, attach the directory you need to the Project tool window.
Running SQL files
Run an SQL file
Using a Database tool window context menu action:
Right-click a data source, or a schema and select.
In the file browser window that opens, navigate to the SQL file that you want to apply.
Dragging an SQL script file:
Open the Project tool window, navigate to the SQL file, and select it.
Drag the SQL file to the data source or schema in Database tool window that you want to run it against.
Run an SQL file for several data sources
In the Project tool window ( ), select file or files that you want to run.
Right-click the selection and navigate to Run <configuration_name> (or press ⌃ ⇧ F10). This action creates a temporary run configuration.
In the Edit Configuration window that opens, click the Add button () in the Target data source / schema pane and select data sources or schemes against which you want to run selected files.
You can click the Recent button () to select data sources that you used recently.
Run individual statements
Open an SQL file in AppCode.
Click the statement that you want to execute. If you want to execute more than one statement, select (highlight) the necessary statements.
Press ⌃ ⏎ or select Execute from the context menu.
Select the query console where you want to execute the statement.
Configuring a dialect for SQL files
For better coding assistance, assign an SQL dialect to an SQL file. An SQL dialect is a DBMS-specific version of SQL.
AppCode lets you specify the SQL dialect for an individual file or all SQL and DDL files that can be stored in a directory, in your project, or on your computer.
Specify a dialect for a single SQL file
Click the dialect list, which is in the upper-right corner of the window.
Select a dialect from the dialect list.
Specify a dialect for multiple SQL files
Open settings by pressing ⌃ ⌥ S and navigate to.
Click the Add button and select directories or files for which you want to change a dialect.
Click the SQL Dialect cell and select the necessary dialect.
Apply changes and click OK.