Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6877 Views
- I also Faced
- E-Mail Answers
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 self-referencing constraint?
What is the use of dclgen in db2?
can we drop column from a table
What do you mean by NOT NULL? When will you use it?
What does reorg do in db2?
What is package versioning? Please give an example.
What are the disadvantages of PAGE level lock?
define clustering index.
What is db2 and what is the use of db2 optimizer?
explain about index with examples
db2 restart logic ?
is it compulsory commitment control in journal?
COBOL 
