search

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.54k stars 899 forks source link

Allow edit records from a query #1762

Open ritoscue opened 6 years ago

ritoscue commented 6 years ago

SQL Operations Studio Version: sqlops 0.30.6 It would be great to be able to edit the records obtained from a query

kevcunnane commented 6 years ago

Have you tried the Edit Data feature? If you right-click on a table/view in the Servers tree you can choose to edit data. This gives you an editable grid, and you can use the "Show SQL Pane" to edit the query used for getting the data and add in WHERE clauses.

image

ritoscue commented 6 years ago

The behavior of "Show SQL Pane" is almost what I want, but I think it has two incovenients:

1) There are too many steps: Tables -->Look for specified table --> Right clic in Edit tables --> Clic in "Show SQL Panel" 2) On "Show SQL Panel" you can only edit rows from the originally targeted table. if you want edit another table you should do above step

For these reasons, I would prefer "Show SQL Panel" funcioanality to be available on query editor.