Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to remove NOT NULL constraint from columns?

Re: How to remove NOT NULL constraint from columns?

From: DJ <nospamplease_at_goaway.com>
Date: Mon, 15 Mar 2004 01:32:24 -0000
Message-ID: <LI75c.10$xb2.1@newsfe1-win> 






"Andrew" <myfam_at_surfeu.fi> wrote in message
news:c5826e91.0403141700.54b3428d_at_posting.google.com...


> Hi,

> what is the easiest way to convert table so that NOT NULL constraint

> will be removed? Table is used by an application and has data.

>

> Thanks,

> Andrei



well a column is not null, not  table a table



so you would do



alter table xxx <column_name> null;
Received on Sun Mar 14 2004 - 19:32:24 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US