Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ALTER TABLE to allow NULLS

Status
Not open for further replies.
jestrada101

jestrada101

Technical User
Mar 28, 2003
332
How can I modify a column to allow NULL values. Currently it is set with NOT NULL and data exists within the table.

Thanks for any guidance.

JE
 
Sort by date Sort by votes
Hi,

Code: 
alter table <table_name> modify (<column_name> null);

Gunjan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
355
jj10438
J
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
1K
carp
carp
Livia8
  • Locked
  • Question
Alternative to &quot;locate&quot; command
Replies
0
Views
898
Livia8
Livia8
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
TheLazyPig
  • Locked
  • Question
Separate 1 row value to multiple rows
Replies
4
Views
985
carp
carp

Part and Inventory Search

Sponsor

Back
Top