dump definition of VIEWs

tikuanglee's profile image tikuanglee posted 12 years ago in Import/Export Permalink
How to export definition of multiple views ? Right now, "export database to SQL" will dump the views as tables (i.e. output table structure, but not the definition of views).
tikuanglee's profile image tikuanglee posted 12 years ago Permalink
sorry. The "SQL Export" actually work. I can dump the definition of all views without problem.
ansgar's profile image ansgar posted 12 years ago Permalink
Yes, views are dumped as tables first, to overcome dependencies between two views of which the second one is required to create the first one. After all tables have been dumped, the actual view definitions are dumped.

Please login to leave a reply, or register at first.