U can get better information in the following query:

Select sysObj.id, sysObj.name, Col.name,

'Datatype'=Case When typ.name in ('char','varchar') Then typ.name+'('+Cast(Col.max_length as varchar(10))+')'

When typ.name = 'nvarchar' AND Col.max_length<>-1 Then typ.name+'('+Cast(Col.max_length/2 as varchar(10))+')'

When typ.name = 'nvarchar' AND Col.max_length=-1 Then typ.name+'(MAX)'

When typ.name = 'decimal' Then typ.name+'('+Cast(Col.precision as varchar(5))+','+Cast(Col.scale as varchar(5))+')'

Else typ.name

End, 'Length'=Col.max_length, 'isNullable'=Case When Col.is_nullable = 1 Then 'Yes' Else 'No' End,

'isIdentity'=Case When Col.is_identity = 1 Then 'Yes' Else 'No' End, Col.column_id

From sys.columns Col

Inner Join sys.sysobjects sysObj ON sysObj.id = Col.object_id

Inner Join sys.types typ ON typ.user_type_id = Col.user_type_id

Where sysObj.xtype = 'U'

and sysObj.name like 'ma_Parts%'

order by sysObj.name, Col.column_id;