Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 378F39FC29A for ; Fri, 19 Oct 2007 02:34:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99039-04 for ; Fri, 19 Oct 2007 02:34:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 55DED9FBFD9 for ; Fri, 19 Oct 2007 02:34:22 -0300 (ADT) Received: from ashishk ([220.227.213.66]) (authenticated bits=0) by pro33.abac.com (8.14.1/8.14.1) with ESMTP id l9J5XoKG020244 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 18 Oct 2007 22:34:12 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <003d01c81211$b72d9160$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "yogesh" , References: <1192687310.749557.227290@q5g2000prf.googlegroups.com> Subject: Re: Drop Not Null Date: Fri, 19 Oct 2007 10:39:38 +0530 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/186 X-Sequence-Number: 27100 alter table table_name alter column column_name drop not null; ----- Original Message ----- From: "yogesh" To: 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