reading default value of a column

[yogi butola]

Hi all

This is urgent.

In my application I want to read the default value of a column.

Pls help

[Shailesh Chandra]

This method will return you default value of column.

public String getColumnDefaultValue(Connection conn,String TableName,String ColumnName) throws Exception
{
String columnDefaultVal = "";
DatabaseMetaData md = conn.getMetaData() ;
ResultSet rs = md.getColumns(conn.getCatalog(), md.getUserName(),TableName,ColumnName);
 
if(rs.next())
{
 columnDefaultVal =  rs.getString("COLUMN_DEF");
}
 
System.out.println("Default Value of Column is " + columnDefaultVal );
return columnDefaultVal;
 
}

Shailesh