Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6775 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 solved 818 error
4 Answers Keane India Ltd, Wipro,
What is the maximum length of sqlca?
How do you define a correlated name?
what is REORG? what is the use?
What does it mean if the null indicator has -1, 0, -2?
How do I add a column to an existing table in db2?
wht r the requirements for writing a cobol-db2 pgm ?
What is ACQUIRE/RELEASE in BIND?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What are the contents of dclgen?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
If I have a view which is a join of two or more tables, can this view be updateable?
COBOL 
