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...


What is ALTER ?

Answers were Sorted based on User's Feedback



What is ALTER ?..

Answer / s

ALTER is a DDL (data definition language) statement to make
changes to the description of the table.

Is This Answer Correct ?    3 Yes 0 No

What is ALTER ?..

Answer / om yadav

modify the structer of table.
1. add column.
2. midify column.
3. drop column.
4. add or remove constraint.

Is This Answer Correct ?    1 Yes 0 No

What is ALTER ?..

Answer / jitendra

ALter is to change db2 table definition. for eg:
Alter tablename
add column number(11,2)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


What is the picture clause of the null indicator variable?

6 Answers  


what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,


What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,


What is temporal table in db2?

0 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


What are the three types of page locks that can be held?

1 Answers  


What is isolation level in db2?

0 Answers  


What is the use of predicate?

0 Answers  


Which command is used to remove all rows from a table?

0 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


Categories