Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

can we drop column from a table

Answer Posted / kumar

It is not possible directly. Indirectly we could do it.
Create a view by eliminating the column (th one to be
deleted). Drop the table or create a new table. Copy from
the view to the newly created table. Pl correct if I'm
wrong.

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute stored procedures?

1175


What is the default page size of buffer pools?

1167


What is cursor stability in db2?

1414


What is rebind in db2?

1117


On which levels locks can be applied?

1201


Can there be more than one cursor open for any program?

1223


What is the maximum No of rows per page?

1110


When the like statement is used?

1280


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2436


Define declaration generator (dclgen).

1172


Which component is responsible for db2 startup and shutdown?

1083


What is precompiler in db2?

1076


What is the maximum size of a char data type in db2?

1050


What is a db2 tablespace?

1118


What language is db2 written in?

1102