SELECT 
AC.name, InPrimaryKey=CAST(ISNULL(cik.index_column_id, 0) AS bit),
IsForeignKey=CAST(case when F.parent_object_id is null then 0 else 1 end AS bit),
SystemType=ISNULL(Z.name, ''),
Length=CAST(CASE WHEN Z.name IN ('nchar', 'nvarchar') AND AC.max_length <> -1 THEN AC.max_length/2 ELSE AC.max_length END AS int),
NumericPrecision=CAST(AC.precision AS int),
NumericScale=CAST(AC.scale AS int),
AC.is_nullable,AC.is_computed,
IsSparse=CAST(AC.is_sparse AS bit),
IsColumnSet=CAST(AC.is_column_set AS bit),
ColDRIDefName=object_name(F.constraint_object_id)
from MyDatabase.sys.tables T
inner join MyDatabase.sys.all_columns AC on AC.object_id=T.object_id
left join MyDatabase.sys.indexes IK ON ik.object_id = AC.object_id and 1=ik.is_primary_key
left join MyDatabase.sys.index_columns CIK ON cik.index_id = ik.index_id and cik.column_id = AC.column_id and cik.object_id = AC.object_id and 0 = cik.is_included_column
left join MyDatabase.sys.types AS Z ON (Z.user_type_id = AC.system_type_id and Z.user_type_id = Z.system_type_id) or ((Z.system_type_id = AC.system_type_id) and (Z.user_type_id = AC.user_type_id) and (Z.is_user_defined = 0) and (Z.is_assembly_type = 1))
left join MyDatabase.sys.foreign_key_columns F on F.parent_column_id = AC.column_id and F.parent_object_id = AC.object_id
where (T.name='MyTableName' and SCHEMA_NAME(T.schema_id)='dbo')
order by AC.column_id ASC