Cannot alter view

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

Parents Reply Children