在线等待--存储过程中怎么能知道某个表是否含有Identitiy=true 的字段?

如题。
表的属性好像是在sysobject中xtype='U'的记录。
---------------------------------------------------------------

联机丛书原原本本语句:
SELECT TABLE_NAME, IDENT_INCR(TABLE_NAME) AS IDENT_INCR
FROM INFORMATION_SCHEMA.TABLES
WHERE IDENT_INCR(TABLE_NAME) IS NOT NULL

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus