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

Comment whether the cursor is closed during commit or not.

1039


What are the uses of db2 optimizer?

1221


How can you quickly find out the # of rows updated after an update statement?

984


How to access db2 tables in mainframe?

990


What are host variables in db2?

991


What is the use of db2?

1004


What is reorg and runstats in db2?

1142


What is db2 stogroup?

1095


Describe major components of db2?

1039


What are bind parameters in db2?

980


What are the different types of base tables?

1026


What is multi row fetch in db2?

985


What is the maximum number of columns in a db2 table?

1213


Explain db2.

990


How do you find the maximum value in a column in db2?

1052