判斷表中是否存在SQL自增列
如何判斷表中是否存在SQL自增列呢？這是很多人都提到過的問題，下面就為您介紹判斷表中是否存在SQL自增列的實現方法，供您參考。
判斷Table是否存在SQL自增列(Identity column)：
declare @Table_name varchar(60)
set @Table_name = '';
if Exists(Select top 1 1 from sysobjects
Where objectproperty(id, 'TableHasIdentity') = 1
and upper(name) = upper(@Table_name)
)
select 1
else select 0
-- or
if Exists(Select top 1 1 from sysobjects so
Where so.xtype = 'U'
and upper(so.name) = upper(@Table_name)
and Exists(Select Top 1 1 from syscolumns sc
Where sc.id = so.id
and columnproperty(sc.id, sc.name, 'IsIdentity') = 1
)
)
select 1
else select 0
判斷Table是否存在自增列(Identity column),并查出自增列相關數據：
declare @Table_name varchar(60)
set @Table_name = '';
【編輯推薦】
