Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6886 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 do you mean by cursor?
How to insert more than one record using insert?
Can we insert update delete in view?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
how to fetch multiple records without using cursor
what is the difference between where clause and having clause
How to define the data items to receive the fetch items for the SQL?
Can I use LOCK TABLE on a view?
Can you search give an array in the WHERE clause of a db2 query?
What is a page?
What is reorg in database?
What is db2?
COBOL 
