modify the structer of table. 1. add column. 2. midify column. 3. drop c

What is ALTER ?

Question Posted / om yadav

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the result of open cursor statement?

1030

Is it possible using max on a char column?

1087

How do I change the column size in db2?

1084

How do I connect my db2 database to ibm?

988

Why do we use cursor?

1051

Explain db2.

993

what is diffrence b/w file-aid tool and file-aid utility???

4812

Which components manage deadlocks in db2?

1021

What is dpf in db2?

1051

What is dclgen in db2?

1084

Explain in brief how does db2 determine what lock-size to use?

962

How to execute stored procedures?

1069

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

What is clone table?

999

Is db2 a mainframe database?

946