Changing the attributes of column in a Table

2 posts / 0 new
Last post
Anonymous
Changing the attributes of column in a Table

 

Is it possible to change the attributes of a column of a table after it has been loaded 
with data?
 
I wish to make use of some command like ALTER and change the attributes of the column, can I do this?
 
 
 
For ex:- 
 
a column Student_Marks was defined as NOT NULL and later you decided to change it to NOT NULL WITH DEFAULT. 
 
I need this urgently
 
Thanks in advance
Rajat
"; ; ; ;
Anonymous
re:Changing the attributes of column in a Table

 

Unload the contents of table using IKJEFT01 utility, drop the table, creat the table again with changed attributes. Upload the 
data from the unload created.
 
-Rodger
Log in or register to post comments
Sponsored Listing