File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
I agree. Here's the link:
subject: column default value
It's not a secret anymore!