wood burning stoves 2.0*
The moose likes JDBC and the fly likes column default value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "column default value" Watch "column default value" New topic

column default value

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
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.
shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
no replies yet
It is sorta covered in the JavaRanch Style Guide.
subject: column default value
Similar Threads
Selected columns
MetaData Incomplete?
reading default value of a column
Hibernate parent/child and foreign key relationships mapping
How to get XMLType column value from Oracle using JDBC ?