What is ALTER ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the role of the cursor in db2?

813


What is a db2 tablespace?

782


What is role in db2?

782


Explain package in db2 and its advantages?

832


What is dpf in db2?

855


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

933


What is the latest version of ibm db2?

961


What is copy pending status in db2?

869


How is a typical db2 batch pgm executed?

857


What is a db2 package?

787


Mention the location where the output received from explain statement is stored.

849


What is the difference between cursor stability and repeatable read isolation levels?

906


What is performance tuning db2?

832


How connect db2 database to datastage?

976


Differentiate between cs and rr isolation levels? Where do you specify them?

820