SQL Management Studio问题 [英] SQL Management Studio Issues

问题描述

你好，

我正在尝试使用SQL Management Studio中的工具在Azure SQL Server上编辑我的一个数据库，但是它似乎不起作用.它不会打开要编辑的表，也不会显示我创建的存储过程.

是某种安全措施还是配置错误?

同时，是否存在一些用于将列更改为标识的命令?

Hi there. 

I'm trying to use the tools in the SQL Management Studio to edit one of my databases on Azure SQL Server, but it doesn't seem to work. It doesn't open the table to edit and also, it doesn't show the Stored Procedures that I have created.

Is it some security measure or misconfiguration?

Meanwhile, is there some command to change a column to identity?

推荐答案

您好.
我正在尝试使用SQL Management Studio中的工具在Azure SQL Server上编辑我的一个数据库，但是它似乎不起作用.它不会打开要编辑的表，也不会显示我创建的存储过程.

是某种安全措施还是配置错误?

同时，是否有一些命令可以将列更改为标识?

Hi there. 

I'm trying to use the tools in the SQL Management Studio to edit one of my databases on Azure SQL Server, but it doesn't seem to work. It doesn't open the table to edit and also, it doesn't show the Stored Procedures that I have created.

Is it some security measure or misconfiguration?

Meanwhile, is there some command to change a column to identity?

1.如果尚未使用最新版本的SSMS，请尝试

1. try to use the latest version of SSMS if you did not do this yet

2.身份不是列属性，而是表属性.由于我们使用列对其进行配置，因此令人困惑.因此，您不能更改列，也不能添加身份属性，并且一个表只能有一个身份列.

2. identity is not a column properties but a table properties. It is confusing since we configure it using a column. Therefore, you cannot ALTER column and add the identity properties and a table can have only one identity column.

常见解决方案:

2.1添加具有标识的新列(并在需要时删除现有列)

2.1 Add New column with identity (and if needed remove the existing column)

2.2使用SEQUENCE代替identity. 将SEQUENCE作为默认值添加到列中.

2.2 Use SEQUENCE instead of identity. Add the SEQUENCE as default value to the column.

这篇关于SQL Management Studio问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！