How to recompile all Views, procedures and triggers in Firebird?

Asked

Viewed 278 times

0

I need to recompile all Views, procedures and triggers in Firebird, not by Ibexpert, but by Delphi XE2, I will pass an SQL, I would like to know how to perform such a procedure.

  • 2

    There is no recompilation in SQL. What you can do is recreate all the Views, procedures and triggers of your BD. Maybe your problem isn’t exactly that, and you should clarify better what you’re trying to get.

  • Yes I would like to recreate, but I would like to know if there is any command that I can perform by Delphi for such procedure, because by the IBEXPERT I perform, I would like to leave a function in the system if it is possible.

  • 1

    Just take the SQL generated in Ibexpert and send it as a script in Delphi. But honestly it doesn’t make sense... You shouldn’t have to do this.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.