What is ALTER ?
- 3 Answers
- 6099 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 |
select 100 records from million records ?
What is the difference between primary key & unique index ?
What is the purpose of using commit?
What is the difference between Primary key and unique index?
What is the role of the data page in the db2 database?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is an inner join, and an outer join ?
what is dynamic cursor?gives syntax for this?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
how to resolve -805. give clear explination for that
What is the size of a data page?
COBOL 
