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`ASselect `listaprodutos`.`IdProduto` AS `IdProduto`,`listaprodutos`.`Ordem` AS......
Which database are you using?
Powered by IDERA