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
Comments
Post a Comment