查詢指定 Table 目前的索引值
DBCC CHECKIDENT (yourtable)
Example
1 | USE AdventureWorks2012; |
重新建立你的索引值
DBCC CHECKIDENT (yourtable, reseed, new index)
1 | USE AdventureWorks2012; |
參考
(fin)
查詢指定 Table 目前的索引值
DBCC CHECKIDENT (yourtable)
Example
1 | USE AdventureWorks2012; |
重新建立你的索引值
DBCC CHECKIDENT (yourtable, reseed, new index)
1 | USE AdventureWorks2012; |
(fin)