Query all user tables with auto-incrementing columns in the database.

Most of the time, we need to find all the database tables with auto-incrementing columns in the database. When there are many database tables, it is too troublesome to query them by ourselves,

So I wrote a script to help us find and print the database table name. The Code is as follows:

---- Query all tables with auto-incremental IDs in the database
Declare curtablename cursor local
Select name from SYS. objects where type = 'U'
Open curtablename
Declare @ table_name varchar (100)
Begin

Fetch next from curtablename into @ table_name
While @ fetch_status = 0
Begin
Fetch next from curtablename into @ table_name

If exists (select top 1 1 from sysobjects
Where objectproperty (ID, 'tablehasauth') = 1
And upper (name) = upper (@ table_name)
)
Print @ table_name
End
End

Close curtablename
Deallocate curtablename