SqlServer教程

SQL SERVER ->> 查找自增列（IDENTITY）为INT的表剩余的自增数值剩余量

本文主要是介绍SQL SERVER ->> 查找自增列（IDENTITY）为INT的表剩余的自增数值剩余量，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

 

SELECT B.NAME table_name, A.NAME AS column_name, d.name AS data_type, C.rowcnt, IDENT_CURRENT(B.NAME) AS IDENT_CURR, POWER(CAST(2 AS BIGINT),31)-1-IDENT_CURRENT(B.NAME) AS remaining
FROM sys.columns a
JOIN sys.types d ON a.system_type_id = d.system_type_id
JOIN sys.objects b ON A.object_id = B.object_id
JOIN sys.sysindexes c ON c.id = b.object_id AND c.indid IN (0,1)
WHERE is_identity = 1
AND d.name='int'
ORDER BY IDENT_CURR DESC

 

这篇关于SQL SERVER ->> 查找自增列（IDENTITY）为INT的表剩余的自增数值剩余量的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
您可能喜欢
栏目导航