Home » Developer & Programmer » Designer » constraint
constraint [message #90593] Wed, 05 May 2004 02:47 Go to next message
Chandra Kishor Ravi
Messages: 4
Registered: April 2004
Junior Member
How can add NOT NULL constraint, after creating the table ?

plz help me
Ravi
Re: constraint [message #90599 is a reply to message #90593] Sun, 09 May 2004 22:33 Go to previous messageGo to next message
abcd
Messages: 7
Registered: November 2001
Junior Member
alter table my_table modify ( my_column not null ) ;
Re: constraint [message #90602 is a reply to message #90593] Tue, 11 May 2004 03:36 Go to previous message
raviranjan
Messages: 41
Registered: April 2004
Member
abe yaar kuchh to reading kiya kar...........
alter table table_name
modify (col name datatype(width) not null);
ho gaya na............
Previous Topic: Sequence
Next Topic: Design
Goto Forum:
  


Current Time: Thu Mar 28 18:15:38 CDT 2024