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 / nitesh

yes we can drop any column
ALTER TABLE <TABLENAME> DROP COLUMN <COLUMNNAME>
e.g ALTER TABLE EMP DROP COLUMN NAME

Is This Answer Correct ?    20 Yes 36 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does db2 stand for?

1025


What does a deadlock mean in DB2?

1167


What is cobol db2?

999


Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104


What parameters are used to control the free space in DB2?

1056


How do I optimize a query in db2?

1101


What is the max length of sqlca?

1216


What is the role of union all and union

1127


What is the use of value function?

1149


What does db2 mean?

1017


When the like statement is used?

1222


Explain correlated sub-queries.

1031


How many types of page locks can be held in db2?

1040


What is db2 instance?

1094


Mention data types used in db2 ?

1156