Re: Not Null Syntax ---

Greg,

ALTER TABLE mytable MODIFY ( mycolumn NOT NULL);

As for dropping a column, you have to recreate the table.

create table new_table as (select c1, c2, c3, ... cn FROM old_table); drop table old_table;
rename new_table to old_table;

Regards,
Charles_Dye_at_corp.dialog.com

> From owner-oracle-l_at_CCVM.SUNYSB.EDU Tue Jan 16 10:27:10 1996
> Date: Tue, 16 Jan 1996 11:43:54 -0600
> From: Gregory Martin <gregory.j.martin_at_MEDTRONIC.COM>
> Subject: Not Null Syntax ---
> X-To: ORACLE-L_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>
>
> What is the syntax for removing a not null constraint from a column...
>
> The ALTER TABLE pages in the manual say it can be done but do not show the
> syntax.
>
> Thanks.
>
Received on Tue Jan 16 1996 - 15:53:46 CST