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
5527
June 14, 2006 08:54AM
2441
June 14, 2006 09:04AM
2956
June 14, 2006 09:25AM
2341
June 14, 2006 11:13AM
2700
June 14, 2006 11:22AM
2429
June 14, 2006 11:31AM
2830
June 14, 2006 11:39AM
2626
June 14, 2006 11:52AM
2535
June 14, 2006 02:04PM
2535
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.