SQL2005_讀取描述

SELECT Fn.name as ColEName, Fn1.[value] as ColCName
FROM syscolumns Fn LEFT OUTER JOIN
sys.extended_properties Fn1 ON Fn.id = Fn1.major_id AND Fn.colid = Fn1.minor_id