SQL FINDING ALL THE TABLE NAME COLUMN NAME WHICH HAVING IDENTITY FIELD AUTO INCREMENT
SQL FINDING ALL THE TABLE NAME COLUMN NAME WHICH HAVING IDENTITY FIELD AUTO INCREMENT --FINDING ALL THE TABLE NAME & COLUMN NAME WHICH IDENTITY IS ON(1) SELECT C.NAME AS COLNAME,T.NAME AS TABLENAME,C.IS_IDENTITY FROM SYS.COLUMNS C INNER JOIN SYS.TABLES T ON C.OBJECT_ID=T.OBJECT_ID WHERE C.IS_IDENTITY=1 This post h download file now