how to modify a view

["J. Manuel Velasco - UBILIBET" <tech(at)ubilibet(dot)com>]

Hello,

The DB I am using has views. I need to modify the view adding one field to the QUERY that build the query.

When I edit the VIEW and add the field, I get the error that tells me "It's not possible to change columns number in a view"

So, do I need to remove the complete VIEW and create a new one ? Or there is other way to modify the view. ?¿

Thanks in advance,

--