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?
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.