How do I add a column to a table in db2?
- 1 Answers
- 1201 Views
- I also Faced
- E-Mail Answers
Answer / Vikrant Gautam
To add a column to a table in DB2, you can use the ALTER TABLE command followed by the ADD COLUMN clause. For example: ALTER TABLE table_name ADD COLUMN column_name data_type.
| Is This Answer Correct ? | 0 Yes | 0 No |
wht r the requirements for writing a cobol-db2 pgm ?
What's the maximum number of characters that a tablename can have?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
what is the difference between declaring the cursor in WS section and Procedure division?
Is there any advantage to denormalizing DB2 tables?
What is universal database?
How to restart a DB2 program?
What is sqlca’s maximum length?
How to find the maximum value in a column in the db2 database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is reorg in database?
What is a trigger in the db2 database?
COBOL 
