distal-attribute
distal-attribute
distal-attribute
distal-attribute

dump definition of VIEWs

tikuanglee posted 2 years ago in Import/Export
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 posted 2 years ago
sorry. The "SQL Export" actually work. I can dump the definition of all views without problem.
ansgar posted 2 years ago
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.