What is ALTER ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the difference between normal select query and currosor
What is the picture clause of the null indicator variable?
what is difference between Static call and Dynamic call? How does it function?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is temporal table in db2?
What is Skeleton cursor table (SKCT)?
How do you do the EXPLAIN of a dynamic SQL statement?
What are the three types of page locks that can be held?
What is isolation level in db2?
What is the use of predicate?
Which command is used to remove all rows from a table?
What is an alias and how does it differ from a synonym?