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 dbrm? What it contains?

1147

How to test SQL -911 error while developing COB-DB2 program

7528

What is the physical storage length of date data type?

1233

Can one database have multiple instances?

1035

What is check constraint. Explain with example.

1083

Explain about rct in db2?

1087

What is a db2 table?

989

Which command is used to remove all rows from a table?

1090

What is blu acceleration in db2?

1047

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

1067

How do I import a csv file into db2?

966

What is copy pending status in db2?

1102

Why do we bind in db2?

1195

What is the purpose of using commit?

1081

Is db2 relational database?

962