Connection conn =session.connection();

// Get DatabaseMetaData
      DatabaseMetaData dbmd = conn.getMetaData();

      // Get all column types for the table "ITEM", in schema
      // "dbo" and catalog "test".

     /*
     The below will return a Resultset contains rows and each rows contain      column description. Try to interogate the result set  for one row to see where is the column comment. The below is a sample which is missing some columns interogation ( col 5, etc...)
 

      */
      ResultSet rs = dbmd.getColumns("test", "dbo", "ITEM", "%");

      // Printout table data
      while(rs.next())
      {
          // Get dbObject metadata
          String dbObjectCatalog = rs.getString(1);
          String dbObjectSchema = rs.getString(2);
          String dbObjectName = rs.getString(3);
          String dbColumnName = rs.getString(4);
          String dbColumnTypeName = rs.getString(6);
          int    dbColumnSize = rs.getInt(7);
          int    dbDecimalDigits = rs.getInt(9);
          String dbColumnDefault = rs.getString(13);
          int    dbOrdinalPosition = rs.getInt(17);
          String dbColumnIsNullable = rs.getString(18);

          // Printout
          System.out.println("Col(" + dbOrdinalPosition + "): " + dbColumnName
                    + " (" + dbColumnTypeName +")");
          System.out.println("   Nullable: " + dbColumnIsNullable +
                    ", Size: " + dbColumnSize);
          System.out.println("   Position in table: " + dbOrdinalPosition
                    + ", Decimal digits: " + dbDecimalDigits);
      }

      // Free database resources
      rs.close();
      conn.close();