How to modify a view?

frnk4360

New member
I have created a view and now need to modify it, but I can't find anyway to access the View.
The SQL for views must be held somewhere - can anybody point me in the right direction?

thanks

Frank
 

eugenio

Administrator
Staff member
Hello,
you cannot modify an SQL VIEW from the DaDaBIK interface, you have to drop it and recreate it.
If you want to see the current SQL definition you have to execute a "SHOW CREATE VIEW view_name" sql command.

Best,
 
Top