SQL Server 2008 R2 (SP1) select coalesce(cast(i1.key_ordinal as char(2)), '') as PK, coalesce(cast(i2.key_ordinal as char(2)), '') as UQ, y1.name, c1.max_length, c1.precision, c1.scale, case when c1.is_nullable = 0 then 'NOT NULL' else '' …