Select the MS SQL: Manage Connection Profiles command. Select Plain Text on the lower status bar, or press Ctrl+ K > M, and select SQL from the languages dropdown.Ī SQL file, such as the empty SQL file you created, must have focus in the code editor before you can execute the mssql commands. Visual Studio Code opens a new Plain Text file by default. The mssql extension enables mssql commands and T-SQL IntelliSense in the code editor when the language mode is set to SQL. Select the SQL Server (mssql) extension, and then select Install.Īfter the installation completes, select Reload to enable the extension. In the Command Palette, select Extensions: Install Extensions from the dropdown. In Visual Studio Code, select View > Command Palette, or press Ctrl+ Shift+ P, or press F1 to open the Command Palette. Install the mssql extension in VS Codeĭownload and install Visual Studio Code on your machine.

The mssql extension for VS Code includes the SQL Database projects extension with support for SQL projects on Windows, macOS, and Linux. The mssql extension for Visual Studio Code lets you connect to a SQL Server, query with Transact-SQL (T-SQL), and view the results. This article shows how to use the mssql extension for Visual Studio Code (VS Code) to work with SQL Server and Azure SQL databases on Windows, macOS, and Linux. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

Does apex sql work for azure sql