Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2012 @ 14:39:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Vinod,

You can also use dbc.columns table to find what you are looking for.

     select *
        from dbc.columns
        where tablename='xxxx' and Nullable='N';

Thanks

Meher
Teradata India Pvt Ltd.

	<Prev	Next>		<<First	<Prev	Next>	Last>>