Equivalent for all_catalog
Hello,
Iam in the process of converting database from oracle/db2 to mysql.
In oracle I used to create a view using oracle and db2 with these commands :
ORACLE :
create view testView(name) as select table_name from all_catalog
DB2 :
create view testView(name) as select tabname from syscat.tables
What is the equivalent SQL Command to create a view in MYSQL ?
Subject
Views
Written By
Posted
Equivalent for all_catalog
5792
June 14, 2006 08:54AM
2568
June 14, 2006 09:04AM
3148
June 14, 2006 09:25AM
2457
June 14, 2006 11:13AM
2818
June 14, 2006 11:22AM
2539
June 14, 2006 11:31AM
2959
June 14, 2006 11:39AM
2733
June 14, 2006 11:52AM
2640
June 14, 2006 02:04PM
2636
June 14, 2006 06:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.