DBCC-->Database Console Commands
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/database-console-commands
DBCC CHECKIDENT (Transact-SQL)
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkident-transact-sql
Checks the current identity value for the specified table in SQL Server 2017 and, if it is needed, changes the identity value. You can also use DBCC CHECKIDENT to manually set a new current identity value for the identity column.
Syntax
DBCC CHECKIDENT ( table_name [, { NORESEED | { RESEED [, new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ]
Arguments
table_name
Is the name of the table for which to check the current identity value.
The table specified must contain an identity column. Table names must
comply with the rules for identifiers. Two or three part names must be delimited, such as 'Person.AddressType' or [Person.AddressType].
NORESEED
Specifies that the current identity value should not be changed.
RESEED
Specifies that the current identity value should be changed.
new_reseed_value
Is the new value to use as the current value of the identity column.
WITH NO_INFOMSGS
Suppresses all informational messages.
Example
DBCC CHECKIDENT(tbm_prg_program,NORESEED) --检索已经使用过的最大值 DBCC CHECKIDENT(tbm_prg_Program,RESEED,4) --重置已经使用过的最大值
作者:Chuck Lu GitHub |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 全程不用写代码,我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2015-08-28 TeeChart的最小步长和最大步长