Saturday, October 15, 2011

Get underlying sql query of a view - Oracle, MySQL and SQL Server

View name is `book_info`

Oracle
SELECT text FROM all_views WHERE view_name = '%book_info%';
MySQL
SHOW CREATE VIEW book_info;
SQL Server
SELECT View_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE Table_Name='book_info';

No comments:

Post a Comment