Thread: alter query
View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 06:30 AM
bikkaran@in.ibm.com
 
Posts: n/a
Default alter query

hi ,

i have some simple doubt in DB2
1. can we disable or enable an INDEX.
2. can we drop a column from a table .
3. can we change the datatype of a column i.e say from varchar to
integer

Please help me update my knowledge.

thanks
bikash

Reply With Quote