MetaData Incomplete?

[Gregg Bolinger]

I am needing to get some information about the columns in my database but I am not sure if the ResultSetMetaData is incomplete or if there is another way to obtain this information.
I am needing to get the length, default value, and description of each column in a table.

[Gregg Bolinger]

Ok, figured out the length. Still needing the others.

[Bas Holland]

Hello Gregg Bolinger,

you did find out how to read the length of a resultSet.

I'm still searching , please : let me know!

[Shailesh Chandra]

Originally posted by Gregg Bolinger:

I am needing to get the length, default value, and description of each column in a table.

DatabaseMetaData will do this job

here is the method I had written for one of the previous post

public void getColumnDefaultValue(Connection conn,String TableName,String ColumnName) throws Exception
{
 
DatabaseMetaData md = conn.getMetaData() ;
ResultSet rs = md.getColumns(conn.getCatalog(), md.getUserName(),TableName,ColumnName);
 
if(rs.next())
{
 System.out.println("Column Name is "      + rs.getString("COLUMN_NAME"));
 System.out.println("Column Size is "      + rs.getString("COLUMN_SIZE"));
 System.out.println("Column  DataType is " + rs.getString("DATA_TYPE")); //int => SQL type from java.sql.Types
 System.out.println("Column Remarks is "   + rs.getString("REMARKS"));
 System.out.println("Default value is "    + rs.getString("COLUMN_DEF"));
 
}
 
}
 

thanks
[ April 11, 2005: Message edited by: Shailesh Chandra ]

[Shailesh Chandra]

Just Wanted to mention that this method was written for one column
to get Details of all columns pass the "%" as the value of argument
String ColumnName, and change if(rs.next()) to while(rs.next())

Bas Holland : Just noticed that that original post is more than 1 year old its better to start a new thread

Shailesh
[ April 11, 2005: Message edited by: Shailesh Chandra ]