SELECT  a.*,b.IS_IDENTITY 
FROM INFORMATION_SCHEMA.COLUMNS a 
JOIN sys.columns b on a.COLUMN_NAME = 你需要查询的字段
                                                                            ©著作权归作者所有
                                            
                SELECT  a.*,b.IS_IDENTITY 
FROM INFORMATION_SCHEMA.COLUMNS a 
JOIN sys.columns b on a.COLUMN_NAME = 你需要查询的字段