Random Tips.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment