aspose file tools*
The moose likes JDBC and the fly likes Identify not null columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Identify not null columns" Watch "Identify not null columns" New topic

Identify not null columns

Kishan Kumar
Ranch Hand

Joined: Sep 26, 2000
Posts: 130
Is there is anyway we can identify columns with "not null" constraint in a given table.
Thanks for your time.

Regards,<BR>V. Kishan Kumar
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

public int isNullable(int column) throws SQLException
Indicates the nullability of values in the designated column.
column - the first column is 1, the second is 2, ...
the nullability status of the given column; one of columnNoNulls, columnNullable or columnNullableUnknown
SQLException - if a database access error occurs
[ July 30, 2002: Message edited by: Jamie Robertson ]
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Identify not null columns