Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [azure-data-studio]

Azure Data Studio is a cross-platform database client from Microsoft that enables working with SQL Server, Azure SQL DB and SQL DW

Filter by
Sorted by
Tagged with
-2 votes
0 answers
32 views

Azure Data Studio Comment Blocks

I have used nested comment blocks in the past while writing queries using SSMS and never thought about whether or not it was alright. I was giving Azure Data Studio a try and noted that it doesn't ...
user avatar
2 votes
1 answer
128 views

Azure Data Studio - intellisence do not see tables in schema other than dbo

Do you know any way to force intellisence in Azure Data Studio to find tables in custom schemas? As you can see I have tables: dbo.TableC schemaA.TableB When typing a query, only TableC is found by ...
user avatar
  • 121
1 vote
1 answer
560 views

Azure Data studio - connection to server in the same network - Error: The received certificate has expired

I am trying to connect to SQL server on my network with Azure Data Studio, and I am getting error: A connection was successfully established with the server, but then an error occurred during the ...
user avatar
6 votes
2 answers
2k views

Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?

Okay. So I'm breaking some new ground and trying to get into Azure Data Studio. I'm having a problem with intellisense that seems to be a bug with Azure Data Studio but I'm not sure. I have issues ...
user avatar
0 votes
1 answer
732 views

Does SQLCMD "!!" command work in Azure Data Studio

In SQL Server Management Studio, it is possible to run batch commands when in SQLCMD mode, using the !! command. However, in Azure Data Studio, this does not seem to work (SQLCMD has been available in ...
user avatar
1 vote
2 answers
598 views

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
user avatar
0 votes
1 answer
407 views

Check constraint age 18< [closed]

Hello I need to create a constraint that chekc the user is 18< before listenning to certain songs but idk how... I tried this : ALTER TABLE Historique_ecoute DROP CONSTRAINT IF EXISTS ...
user avatar
0 votes
0 answers
63 views

CommandLine for Exporting All MS SQL Tables to CSV

On my Mac, I have a docker container running an Ubuntu version of MS SQL. I have a DB running in it and I can access it via Azure Data Studio, and I can view each table individually and export it to ...
user avatar
  • 111
0 votes
1 answer
1k views

How to change results cell padding in Azure Data Studio

In Azure Data Studio, I am trying to change the padding on the cells in the results grid. According to the settings page, this is editable in the settings.json: However, when I navigate to that file ...
user avatar
  • 115
3 votes
1 answer
314 views

How to Parse a query in Azure Data Studio?

In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it). How can I do it the same in Azure Data ...
user avatar
  • 147
1 vote
0 answers
18 views

Is there a way Azure data studio to find and add local databases under a list automatically?

When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time. Generally I use SSMS but am trying to switch away (or just try for fun) ...
user avatar
  • 111
5 votes
2 answers
8k views

How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?

I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud). How can I use Azure Data Studio to generate ...
user avatar
  • 2,178
3 votes
1 answer
685 views

Change expired user password on sql server from linux

I have got a colleague (software developer) working on Linux only. He connects to our SQL Server using a sql login with password. Occasionally the password expires and he has to choose a new one. Up ...
user avatar
1 vote
0 answers
2k views

Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
user avatar
  • 111