Azuredatastudio: Adding functionality of design table structure and edit it.

[VikasShinde]

• SQL Operations Studio Version:
  Microsoft SQL Server Management Studio 13.0.16106.4
  Operating System 6.3.16299

• Suggestions :
  Can you add functionality for edit and create new database table like SSMS.
  also update old database table column and keys.

[cmbarnett87]

@VikasShinde To clarify, are you suggesting that the ability to create a new table like you can in SSMS by right clicking the Tables folder within a database and selecting New > Table... ? I would also like this feature.

[erickangMSFT]

@VikasShinde @cmbarnett87 I think this is Table Designer ask.

[VikasShinde]

@erickangMSFT yes this is Table Designer. SQL Operations Studio is much faster than SSMS. so we need this feature in SQL Operations Studio.

[camckay]

I am pretty sure this is the same or similar to my issue. There doesn't seem to be any way to access the the Design for Views, unless I am just missing it entirely. Hopefully this is something that will be added soon.

[tslin89]

Agreed. Currently, when I need to add new table or modify, I need to open SSMS and do there. I also would love to see Database and Table Properties dialog too. May be with some commonly used basic information and functionalities.

[helbertm]

Agreed with @tslin306 @camckay and @VikasShinde. I'm using ALTER TABLE <...> to change a table's structure or CREATE TABLE to new tables, this is really annoying sometimes. I work only on Mac today and don't have other option like SSMS when i don't have Windows VM with SSMS running.

[matthewblott]

I'd say this is a much needed feature. I use macOS daily and am currently using the proprietary SQL Pro for MSSQL. It's a bit limited in features (and I do occasionally fire up a VM so I can use SSMS when doing more advanced tasks) but it's still my main SQL Server editor because it runs natively on macOS and I can edit tables in design view. I just don't find it practical running ALTER to make table and column changes. It's pretty much the only thing stopping me switching to Operations Studio.

[Cassandra-d]

Would be nice to be able to quickly look at schema and see datatypes, keys, nullability, just like in SSMS.
It is related to the current request, the difference is that it seems overkill to open a designer to just look at schema.
It would be less annoying to be able to expand a tree view like it is presented in SSMS.

[cesarnava]

Yes, it would be nice to add a table designer, which allows you to create or edit tables.

[samuelT2]

Definitely needed, hope this will be soon integrated.

[apootscivica]

Think Table Designer is just an essential must-have feature, as well as View Designer.

[winzig]

Any idea if Microsoft is targeting this feature for 2019?

[luckyexpert]

I too feel like a GUI table editor is the last missing piece that would allow me to use this app over SSMS on a regular basis.

[winzig]

Yeah, where I miss it most is when making a schema change that requires a table to be dropped, re-created with a new schema, filled in with all the old data, etc.

[softgandhi]

+1. this is much needed feature.

[rockneverdies55]

The best thing about SSMS and it is missing in ADS. Oh no.

[jonathangroves]

I hate having to keep a Windows machine just for SSMS - PLEASE add this feature, guys. But above all, keep safe...

[mmcconnell1618]

Can we can an update on if this is on the roadmap or not? It looks like the issue was requested 2.5 years ago and there is a lot of interest. It would be helpful know if this is coming or if I need to purchase a 3rd party tool to use SQL Server from my Mac. Azure Data Studio is great and I really appreciate the Mac support (and also VS Code and VS Mac) but like others have said, that missing table designer is keeping me from adopting it as my primary SQL admin tool.

[yualan]

Hi Marcus, yes this is planned and committed by the team. If there is interest, we could share some of the proposed designs and get feedback. @dzsquared @shueybubbles

[winzig]

Yes, please

On Mon, Jul 6, 2020 at 9:30 PM Alan Yu [e-mail] wrote:

Hi Marcus, yes this is planned and committed by the team. If there is
interest, we could share some of the proposed designs and get feedback.
@dzsquared https://github.com/dzsquared @shueybubbles
https://github.com/shueybubbles

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/microsoft/azuredatastudio/issues/282#issuecomment-654592151,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AAA7AVWREKXJJIS3WMDKKHLR2KQH7ANCNFSM4EGQV5IQ
.

>

[barthermans]

Hi Marcus, yes this is planned and committed by the team. If there is interest, we could share some of the proposed designs and get feedback. @dzsquared @shueybubbles

@yualan Is there anything you can already share?
Really looking forward to this feature!

[yualan]

This came up in the UX benchmark study. Let's revisit.