Community

IDENTITY IN SQL

(Arun Mallick) Exploring each table in SSMS, just to check whether a particular table has IDENTITY property set or not i.e. presence of any IDENTITY column in the given table; might be a cumbersome task, especially when the number of tables in the given database is more than hundred.

Read More - Register for Free Membership