无法查看对象架构Azure Datawarehouse [英] Cannot view object schema Azure Datawarehouse

问题描述

尝试查看view或procedure:

Azure SQL数据仓库中的SQL Server Management Studio 17.4记录错误:

from SQL Server Management Studio 17.4 in Azure SQL Datawarehouse notes the error:

但是，我可以删除并创建所需的任何对象.

I can however, delete and create any object that I want.

如何确保我可以查看对象定义?

How can I work to ensure I can view the objects definition?

已更新

关于将SSMS中的选项设置为SQL Datawarehouse，没有该选项:

Concerning setting the options in SSMS to SQL Datawarehouse, there is not that option:

推荐答案

请在工具...选项"下更改此设置.那应该解决错误.我希望我们不必更改此设置，但是至少有一个解决方法.

Please change this setting under Tools... Options. That should resolve the error. I wish we didn't have to change this but at lease we have a workaround.

在SSMS 17.5中，还有更多选择.您可以让它自动检测所连接的数据库类型并相应地编写脚本.或者，您可以强制它为特定数据库类型编写脚本，如以下屏幕截图所示.

In SSMS 17.5 there are a few more options. You can have it automatically detect what type of database you're connected to and script accordingly. Or you can force it to script for a particular database type like the following screenshot.

在某些版本的SSMS(例如17.5)中似乎存在一个错误，即如果DW用户也不是master数据库中的用户，则脚本编写将失败.最简单的解决方法是让服务器管理员连接到master数据库并运行:

It appears there is a bug in certain versions of SSMS (such as 17.5) where if the DW user isn't also a user in the master database then scripting fails. The easy fix for this is having the server admin connect to the master database and run:

CREATE USER MyUserNameHere FROM LOGIN MyUserNameHere;  

这篇关于无法查看对象架构Azure Datawarehouse的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！