Cannot alter view

by Dec 15, 2019

Hi,

If i create a view teste with a user let´s say rreis and then connect as root user i cannot alter view because it return only the following:

CREATE OR REPLACE VIEW `teste`
AS

If i connect again as rreis i can see the following:

CREATE OR REPLACE VIEW `teste`
AS
select `listaprodutos`.`IdProduto` AS `IdProduto`,`listaprodutos`.`Ordem` AS……

Any idea?

Rui Reis