Crack view in Database
I have database which have some views.
Im using DB VIsualizer tool to run queries and 开发者_JS百科stuff ,now does anyknow how can I get the "Create" code of the View in the DB ,please>
I don't know how to do it in that specific tool, but assuming you're using MySql can use this query
SHOW CREATE VIEW view_name
See: http://dev.mysql.com/doc/refman/5.0/en/show-create-view.html
精彩评论