hi, I want to get all the columns' default value of a table.How do i proceed?I tried using DatabaseMetaData.getColumns(), but the column in the result set returned i.e. COLUMN_DEF is not to be found. An SQL exception is being thrown saying column not found. Could anyone explain the parametes to be passed, i tried using all possible combinations, but still could not get COLUMN_DEF. a code example will help a lot.This is very urgent for me. Thanx in advance. shanks.