how to identify identity column in a table sql server code example

Example: how to get table current identity value in sql server

SELECT IDENT_CURRENT('Pets') AS Result;