Determine whether the table has an auto-increment column (

SQL Server auto-increment Column

Determine whether the table has an auto-increment column (identity column ):

Declare @ table_name varchar (60)

Set @ table_name = '';

If exists (select top 1 1 from sysobjects
Where objectproperty (ID, 'tablehasauth') = 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

Determine whether the table has an auto-increment column (identity column) and check the relevant data of the auto-increment column:

Declare @ table_name varchar (60)
Set @ table_name = '';

 

Declare @ table_name varchar (60)
Set @ table_name = 'zy _ cost_list ';
Select so. Name table_name, -- table name
SC. Name iden_column_name, -- auto-increment field name
Ident_current (so. Name) curr_value, -- current value of the auto-increment Field
Ident_incr (so. Name) incr_value, -- auto-increment field Growth Value
Ident_seed (so. Name) seed_value -- seed value of the auto-increment Field
From sysobjects so
Inner join syscolumns SC
On so. ID = SC. ID
And columnproperty (SC. ID, SC. Name, 'isidentity ') = 1
Where upper (so. Name) = upper (@ table_name)