Dear Experts
When we create table in MS Access we enter description of field in description column. I am able to get the field name and data type from the table but how can I get the description from the table.
Here is the code by which I am getting field name
public ArrayList<String> fetchtable(String value)
{
try
{
makeConnection();
String str1="Select * from "+ value;
ResultSet rs = st.executeQuery(str1);
rsmd = rs.getMetaData();
NumOfCol= rsmd.getColumnCount();
for(int i=1;i<=NumOfCol;i++)
{
ColumnName = rsmd.getColumnName(i);
System.out.println(ColumnName);
columns.add(ColumnName);
}
//System.out.println("Columns Valuessss is:" +columns);
}catch(Exception ae){
ae.printStackTrace();
}
return columns;
}
Kindly refer the image
