Re: Drop Not Null

On Oct 19, 4:20 am, alexkl...@att.net (Alex Kloss) wrote:
> yogesh wrote:
> > Hello Frnds,
> >  What is the Command to drop the  Not Null  Constraint from a Column
> > of the Table.....Please reply asap.............
>
> > Regards,
> >  Yogesh Arora.
>
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
> ALTER TABLE table ALTER COLUMN column DROP NOT NULL
>
> Seehttp://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
> for more information about dropping constraints.
>
> Alex Kloss
>
>  signature.asc
> 1KDownload

Thx for your Support