can alter be used to alter views and indexes

2 posts / 0 new
Last post
Anonymous
can alter be used to alter views and indexes

Alter command is used to make changes to DB2 objects like table, is it possible to alter a view or an index on a table using the alter command? If the alter command cannot be used to alter views and index then what is the other option of changing existing views and indexes

"; ; ; ;
Anonymous
Yes Alter Index and Alter

Yes Alter Index and Alter View are possible.

Alter Index Indexname

Bufferpool BP0/BP1/BP2

close yes/no

FREEPAGE qty PCTFREE qty

Using STOGROUP stogroupname

PRIQTY amount SECQTY ammount

ERASE YES/NO

will do the job for alter index

ALTER VIEW viewname REGENERATE will do the job

or DROP and CREATE the view will go fine.

 

Thanks,

Raja L

Log in or register to post comments
Sponsored Listing