Home » RDBMS Server » Server Administration » How do I get rid of a DEFAULT value on a column
How do I get rid of a DEFAULT value on a column [message #50325] Mon, 11 March 2002 12:08 Go to next message
Gaas
Messages: 2
Registered: March 2002
Junior Member
CREATE TABLE A (
COLUMN1 DATE DEFAULT sysdate);

How do I get rid of the DEFAULT without recreating the table?

Report message to a moderator

Re: How do I get rid of a DEFAULT value on a column [message #50326 is a reply to message #50325] Mon, 11 March 2002 12:18 Go to previous message
saleem
Messages: 65
Registered: January 2002
Member
alter table xyz modify(column_name definition);

Report message to a moderator

Previous Topic: Where I can get the current system change number?
Next Topic: Starting oracle instance (Oracle9i)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 21:00:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.