What is ALTER ?
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 u check the query is executing or not ?where will u check for sqlcode ?
What is Skeleton cursor table (SKCT)?
What does db2 mean?
How to compare data between two tables in db2?
What is an instance database?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
How can you quickly find out the # of rows updated after an update statement?
What is a precompiler?
Give the COBOL definition of a VARCHAR field.