This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
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


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Identify not null columns" Watch "Identify not null columns" New topic
Author

Identify not null columns

Kishan Kumar
Ranch Hand

Joined: Sep 26, 2000
Posts: 130
Hi,
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

ResultSetMetaData.isNullable:
public int isNullable(int column) throws SQLException
Indicates the nullability of values in the designated column.
Parameters:
column - the first column is 1, the second is 2, ...
Returns:
the nullability status of the given column; one of columnNoNulls, columnNullable or columnNullableUnknown
Throws:
SQLException - if a database access error occurs
[ July 30, 2002: Message edited by: Jamie Robertson ]
 
Consider Paul's rocket mass heater.
 
subject: Identify not null columns