Site icon Database Tutorials

How To Identify Tables that has identity columns in a database? and what are incremental values of these identitity columns?(IDENT_INCR Function)

 

With the IDENT_INCR function we can find the incremental value of the identity column in a table. If there is no Identity column in the table, the result will return NULL.

If you want to identify all identity column’s incremental value in the database, you should use the below script:

Exit mobile version