>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 > LEGT JOIN sys.extended_properties ep > ON ep.major_id = t.object_id > AND ep.minor_id = c.column_id >>
>>SELECT o.Name AS ObjectName, >> c.name AS ColumnName, >> ep.value AS ColumnDesc, >> c.colid AS Sequence >>FROM sys.objects o INNER JOIN sys.extended_properties ep >> ON o.object_id = ep.major_id >> INNER JOIN sys.schemas s >> ON o.schema_id = s.schema_id >> LEFT JOIN syscolumns c >> ON ep.minor_id = c.colid >> AND ep.major_id = c.id >>WHERE o.type = 'U' >>ORDER BY ObjectName, Sequence >> >>