Home » SQL & PL/SQL » SQL & PL/SQL » How to remove NOT NULL constraint (Oracle10g)
How to remove NOT NULL constraint [message #399465] Wed, 22 April 2009 06:34 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
How to remove not null constraint from the existing table.
Re: How to remove NOT NULL constraint [message #399468 is a reply to message #399465] Wed, 22 April 2009 06:45 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member
alter table table_name drop constraint constraint_name 


constraint_name u can find from user_constraints for that table_name;

[Updated on: Wed, 22 April 2009 06:46]

Report message to a moderator

Re: How to remove NOT NULL constraint [message #399470 is a reply to message #399465] Wed, 22 April 2009 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you search and try before posting this?

Regards
Michel
Re: How to remove NOT NULL constraint [message #399471 is a reply to message #399465] Wed, 22 April 2009 06:46 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
google is your friend
Previous Topic: how to write this query
Next Topic: ult_smtp and message format
Goto Forum:
  


Current Time: Sun Dec 11 00:26:55 CST 2016

Total time taken to generate the page: 0.11440 seconds