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 rct?

1236

List down the types of triggers in the db2 database?

1033

What is reorg?

1162

What is syscat in db2?

1013

Can we delete records from view?

967

What does db2 mean?

1018

What is the use of commit in db2?

1083

What are union and union all?

983

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

How to execute stored procedure in db2 command editor?

1049

How do I delete a column in db2?

1109

What does runstats do in db2?

1120

What parameters are used to control the free space in DB2?

1057

What is isolation level in db2?

1006

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1105