How to MODIFY a view?

[Former Member]

HI,

For DB tables, we use MODIFY stattement.

For internal tables, we use MODIFY TABLE statement.

But, I want to modify a view then how ?

Please tell me.

[Former Member]

HI,

For DB tables, we use MODIFY stattement.

For internal tables, we use MODIFY TABLE statement.

But, I want to modify a view then how ?

Please tell me.

[ThomasZloch]

removed.

[Former Member]

Hi,

Can you please eloberate your answer and tell me what is 'removed'?

[Former Member]

You can use Modify for VIEW also.

Regards,

ravi

[ThomasZloch]

I posted an answer and afterwards realised it was not quite correct.

Cheers

Thomas

[Former Member]

Hi Ravi,

Please tell me the syntax.

[Former Member]

Hi Ravi,

When I use modify statement, it is giving an error stating that that view is not defined as a table.

[Former Member]

Hi ,

Try VIEW_MAINTENANCE_SINGLE_ENTRY with SUPPRESSDIALOG = 'X'. See Documentation for more

details.

Regards

Saket Sharma