Sometimes, we will suppose to find out the tables which have IDENTITY column...
Below is the code to get the all IDENTITY column tables in a database
SELECT
[schema] = OBJECT_SCHEMA_NAME([object_id]),
[table] = OBJECT_NAME([object_id])
FROM sys.identity_columns;