dump definition of VIEWs
| User, date | Message |
|---|---|
|
Written by tikuanglee
11 months ago Category: Import/Export 3 posts since Sat, 23 Jun 12 |
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). |
|
Written by tikuanglee
11 months ago 3 posts since Sat, 23 Jun 12 |
sorry. The "SQL Export" actually work. I can dump the definition of all views without problem. |
|
Written by ansgar
11 months ago 3958 posts since Fri, 07 Apr 06 |
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. |