Urgent Help on Getting the Column property(NOT NULL) 
Author Message
 Urgent Help on Getting the Column property(NOT NULL)

How can I check if the property of a column is NOT NULL? Please email me
directly,thanks.



Wed, 29 Oct 2003 04:46:40 GMT
 Urgent Help on Getting the Column property(NOT NULL)

[Posted and emailed]


Quote:

> How can I check if the property of a column is NOT NULL?

Have you tried the wasNull method in ResultSet?

Quote:
> Please email me directly,thanks.

Please read where you post in future - Usenet is not a write-only
medium.

--

http://www.pobox.com/~skeet
If replying to the group, please don't mail me at the same time



Wed, 29 Oct 2003 06:09:02 GMT
 Urgent Help on Getting the Column property(NOT NULL)

Quote:

> How can I check if the property of a column is NOT NULL?

Use isNullable() in java.sql.ResultSetMetaData.

Quote:
> Please email me directly,thanks.

Post it here; read it here.

--
Lee Fe{*filter*}an, FFE Software, Inc. ( http://www.***.com/ )
===================================================================
* Check out Database Debunkings ( http://www.***.com/ )
* "The Forum Where Database Matters Are Set Straight"



Wed, 29 Oct 2003 07:36:17 GMT
 Urgent Help on Getting the Column property(NOT NULL)
Use DatabaseMetaData.getColumns() and look at the NULLABLE column.

Daniel Gustafsson - Mimer SQL Development - http://www.mimer.com



Quote:

> How can I check if the property of a column is NOT NULL? Please email me
> directly,thanks.



Thu, 30 Oct 2003 23:44:37 GMT
 Urgent Help on Getting the Column property(NOT NULL)
It's probably better to look at the IS_NULLABLE column.

Daniel Gustafsson - Mimer SQL Development - http://www.mimer.com



Quote:
> Use DatabaseMetaData.getColumns() and look at the NULLABLE column.

> Daniel Gustafsson - Mimer SQL Development - http://www.mimer.com



> > How can I check if the property of a column is NOT NULL? Please email me
> > directly,thanks.



Fri, 31 Oct 2003 00:21:01 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Default for NULL/NOT NULL column property ?

2. Getting rid of the IDENTITY property on a column withou getting rid of the column

3. not null column during CTAS(not null definition did not come across)

4. How to change a NULL column to NOT NULL column

5. Which system column indicate the NULL Property of User's columns

6. How to change the column from NULL to NOT NULL

7. altering the null/not null of an existing column

8. Change existing column from Null to Not Null

9. Converting null columns to not null

10. Alter column type - NULL to NOT NULL

11. Change column from not null to null


 
Powered by phpBB® Forum Software