Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6984 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 |
how to resolve -811 error. give clear explination
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
How to resolve -504 sql code in DB2?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
If I have a view which is a join of two or more tables, can this view be updatable?
When will you chose to run RUNSTATS?
What is cascading rollback?
Can we install 2 different versions of Db2 on same mainframe?
What are the benefits of using the db2 database?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
how can you access index
COBOL 
