CODEWITHSUNDEEP
azureazure-synapse
Mutuelinvestor
Mutuelinvestor

Reputation: 3548

Why can't I see tables in SSMS

I recently created a Microsoft Azure SQL Data Warehouse and used the AdventureWorks sample database. When try to access the database in SSMS, I can not see any of the database Tables, yet I am able to query them.

Researching on the internet, led me to believe this might be a permission issue, so I right clicked the database, selected Properties | Permission to review the View permission. However, when I this, I get the following error message: enter image description here

I've also upgraded to the latest edition of SSMS, I also dropped and reloaded all the tables making sure I used dbo as the Schema.

As anyone come across this problem and do you have a workaround or fix.

Upvotes: 1

Views: 3108

Answers (1)

Ngovkevin
Ngovkevin

Reputation: 153

In scripting options, make sure that the engine edition is set as “Microsoft Azure SQL Data Warehouse Edition” and engine type is “Microsoft Azure SQL Database”.

Tools -> Options -> SQL Server OE -> Under General scripting options

Please let us know if this issue persists. We have a fix in the upcoming release for SSMS which will automatically detect the database source to populate these settings.

Thanks!

Upvotes: 3

Related Questions