Have to ask this newbie question after reading the Synapse documentation...
I just installed Visual Studio with the DB addons, and connect to Synapse SQL Pool. All working fine so far.
However, I am looking for a convenient way to manager relational DBs in a graphical editor, e.g. managing everything around DDL statements.
So far I only found the pure listing of DB objects, but there is no dialogue e.g. for altering tables schema as exists for SQL DB.
In understand that Synapse only serves as an abstraction layer for various DBs, and that it is using general T-SQL. But is there no convenient interface for RDBMS? For instance, I have a table with 150 columns from which I need to change 20 columns - I can certainly write 20 ALTER TABLE statements, but it would be more comfortable to do it via GUI in one go.
Do I miss something here? A somewhere hidden module in VS?