How to identify IDENTITY columns tables in a database

Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:

Views – 533

Leave a Reply