microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.55k stars 898 forks source link

View Foreign Key Relationships (like in SSMS) by double clicking a key in the object explorer #14313

Open nihirisuto opened 3 years ago

nihirisuto commented 3 years ago
Screen Shot 2021-02-16 at 1 59 03 PM

Feature Request: Double clicking on a key in the object explorer on the left pane in Azure Data Studio brings up the Foreign Key Relationships window.

Feels like not having this Window (screenshot is from SSMS) available to me to view Foreign Key Relationships is pretty disadvantageous when using Azure Data Studio. Going further from here, we get the Tables and Columns window. These windows are pretty instrumental in building out joins, and not having this kind of puts me in an awkward spot during my learning (won't be able to do the exercises easily without being able to glance the relationships and associated tables/columns)

--

Sidenote:

I'm relegated to using ADS because I'm currently on an M1 Macbook trying to learn T-SQL, and I no longer have access to a Bootcamp partition to run SSMS. Not entirely related to this feature request, but perhaps might be of some insight for prioritizing making SQL Server work for other M1 users:

Ultimately really hard to learn the Microsoft T-SQL way of doing things (something I need for potential upcoming employment) without a Windows machine, but I personally don't feel like my hardware purchase should only be dictated by one thing when there have been efforts to make this flavor of SQL more cross platform.

Cheers

rw152 commented 1 year ago

I tried to spin up SQL Server in a Docker instance provisioning for amd64 emulation, but there appears to be a QEMU issue and is currently broken

Try opening Docker and go to the settings page (little COG at top of UI). Enable Rosetta... it works for me at least. I have to re-enable the option each time I boot up my computer though, just an FYI. M2 user here.

Screenshot 2023-04-21 at 3 11 28 PM