Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases 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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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 ]
 
wood burning stoves
 
subject: Identify not null columns