The
autoval
column on the
syscolumns
table is "for internal use only". Since SQL 2005, this column always returns
NULL
.
Try using
the sys.columns
view[
^] instead:
SELECT
C.name,
C.is_nullable As isnullable,
T.name As TypeName,
C.is_identity As IsIdentityCol
FROM
sys.columns As C
INNER JOIN sys.types As T
ON T.system_type_id = C.system_type_id
WHERE
C.object_id = OBJECT_ID('TblTransazioni')
ORDER BY
C.column_id
;