distinguish between nullable and mandatory table fields

[jure]

Hello!

Often when I write queries I want to know whether a certain table field is nullable or not. For example, if a column which contains a foreign key is mandatory I can write INNER join otherwise I have to write OUTER join to the master table.

Currently if I want to find out whether a field is nullable or not I have to do "desc

" or go to "View/Edit Table".

It would be great if one could see this info in:
- autocomplete for table columns (similar to autocomplete of function/procedure parameters where non-mandatory parameters are bracketed with [ and ] )
- column list of object browser

Cheers,
Jure

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[jure]

Thanks Marco! Hope to see this feature in the near future