Azuredatastudio: Support drag-n-drop columns and tables into Query Editor

Created on 17 Dec 2018  路  6Comments  路  Source: microsoft/azuredatastudio

Steps to Reproduce:
when writing the query I can not drag tables or columns from server navigation pane. This feature is available in SSMS
annotation 2018-12-17 090330

Area - Query Editor Enhancement Done

Most helpful comment

I really miss this feature.
Possible alternative for columns would be automatic wildcard substitution.

All 6 comments

Please don't limit this to the Columns or tables nodes, we would like to drag-and-drop any object name, or collection of object names. Please make sure this works for all file types as well. For instance, I might want to drag-and-drop instance, database, or table name into a .PS1 file that I am currently working on.

Wondering whether this is a bug since attempting the old drag-and-drop columns feature crashes SSMS your only option a task kill.

I really miss this feature.
Possible alternative for columns would be automatic wildcard substitution.

Wishes: conditional inclusion of [square brackets] only when needed. Formatted list of columns with a choice of commas before or after each name. Then, ahem, star expansion.

DragDrop
Here is a brief gif of the functionality I have been working on, feel free to leave feedback.

That looks awesome!

Since we're working in this area...
could we make it so that if you hold down the Ctrl key or the Shift key, before you drag (Ctrl+{dragging action}), that it copies the full path (URI?) of the object you're dragging?

So in the .gif above, it would copy something like chris-test-server.test-db.dbo.Employees.EmployeeId.

Was this page helpful?
0 / 5 - 0 ratings