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

How connect db2 database to datastage?

765


How do I change the column size in db2?

593


Name the various locking levels available?

637


Mention the various locks that are available in db2.

616


What is commit in db2?

596






What is scrollable cursor in db2?

584


What are iseries servers?

568


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

642


What is the physical storage length of time data type?

673


What is the connection string to connect to the DB2 Database ?

614


What are db2 tables?

649


What is multi row fetch in db2?

610


What is database alias db2?

611


What is db2? Explain.

606


Why do we need reorg in db2?

564