C#

<br />
string strSqlSELECT = "SELECT o.id AS 'ObjectID', " +<br />
		      "CAST(o.Name AS varchar(25)) AS 'TableName', " +<br />
		      "CAST(c.Name AS varchar(25)) AS 'ColumnName', " +<br />
		      "CAST(p.Value AS varchar(50)) AS 'Description', " +<br />
		      "Type = CASE WHEN p.Type=3 THEN 'Table' WHEN p.Type=4  THEN 'Column' ELSE 'UNKNOWN' END " +<br />
  		      "FROM dbo.sysobjects o " +<br />
		      "INNER JOIN dbo.sysproperties p" +<br />
		      " ON o.id = p.id " +<br />
		      "INNER JOIN dbo.syscolumns c " +<br />
	  	      " ON p.smallid = c.colorder " +<br />
		      "WHERE o.id = c.id " +<br />
		      "AND p.type = 4 " +<br />
		      "ORDER BY o.id, o.Name, p.smallid" ;<br />
<br />
       sqlDataAdapter sqlDA = new sqlDataAdapter (strSqlSELECT,Connection) ;<br />
       sqlDA.fill (myDataSet) ;<br />
       <br />
       for (int i=0;i<myDataSet.Tables[0].Rows.Count;i++)<br />
          MessageBox.Show (myDataSet.Tables[0].Rows[i][3].ToString()) ;<br />