Read default values from database connection

Thread view:

Adrian Jetzer - 26 Jan 2004 16:15 GMT

Hi There

I wanna read the meta information from a database. Where
can I get which default values are set for a field in a table?

(I can set default values, so when I insert a dataSet, this
default Values are taken if I don't enter any values in this
field)

Thanks,
Adrian

Reply to this Message

Lee Fesperman - 27 Jan 2004 00:03 GMT

> I wanna read the meta information from a database. Where
> can I get which default values are set for a field in a table?
>
> (I can set default values, so when I insert a dataSet, this
> default Values are taken if I don't enter any values in this
> field)

Use getColumns() in java.sql.DatabaseMetaData. It returns a result set with a column
named -- COLUMN_DEF, which is supposed to contain the default value for the column if
the DBMS supports DEFAULT.

Signature

Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...