如何在Windows Azure中写入种子 [英] how write reseed in windows azure

问题描述

我正在尝试在sql azure数据库中执行RESEED命令.
我想这样:
DBCC CHECKIDENT(''mytable''，seed，7).

显示错误为:此版本的SQL Server不支持DBCC命令"CHECKIDENT".
请任何人帮我.
预先感谢，
nareshrajuu

i am trying to perform RESEED command in sql azure database.
i am trying to like this:
DBCC CHECKIDENT(''mytable'',reseed,7).

showing an error as: DBCC command ''CHECKIDENT'' is not supported in this version of SQL Server.
please any one help to me.
thanks in advance,
nareshrajuu

推荐答案

不确定，但是尝试一下，看看是否可行:

Not sure, but give this a try and see if it works:

ALTER TABLE tableName ALTER COLUMN columnName IDENTITY (1,1)

因此，我发现您面临的问题已在此处报告并得到跟踪: SQL Azure问题5934 [ ^ ]

As such, I found that the issue you are facing is already reported and being tracked here: SQL Azure Issue 5934[^]

这篇关于如何在Windows Azure中写入种子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！