[GENERAL] how to modify a view

[J. Manuel Velasco - UBILIBET]

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, --