Обсуждение: Drop Not Null

Hello Frnds,
 What is the Command to drop the  Not Null  Constraint from a Column
of the Table.....Please reply asap.............

Regards,
 Yogesh Arora.

>>> On Thu, Oct 18, 2007 at  1:01 AM, in message
<1192687310.749557.227290@q5g2000prf.googlegroups.com>, yogesh
<yogesh.arora.daffodil@gmail.com> wrote:
>  What is the Command to drop the  Not Null  Constraint from a Column

http://www.postgresql.org/docs/8.2/interactive/sql-altertable.html

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

See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
for more information about dropping constraints.

Alex Kloss

alter table table_name alter column column_name drop not null;
----- Original Message -----
From: "yogesh" <yogesh.arora.daffodil@gmail.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 18, 2007 11:31 AM
Subject: [ADMIN] Drop Not Null


> 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

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