This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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!