>>SELECT t.name AS TableNAme, c.name AS ColName, c.column_id AS Sequence, >> c.max_length, c.precision, c.scale, c.is_nullable, >> ep.value >> FROM sys.tables t >> JOIN sys.columns c >> ON c.object_id = t.object_id >> LEFT JOIN sys.extended_properties ep >> ON ep.major_id = t.object_id >> AND ep.minor_id = c.column_id >>