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
5397
June 14, 2006 08:54AM
2380
June 14, 2006 09:04AM
2893
June 14, 2006 09:25AM
2294
June 14, 2006 11:13AM
2658
June 14, 2006 11:22AM
2383
June 14, 2006 11:31AM
2789
June 14, 2006 11:39AM
2564
June 14, 2006 11:52AM
2483
June 14, 2006 02:04PM
2491
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.