MySQL Forums
Forum List  »  Oracle

Equivalent for all_catalog
Posted by: Vani Chiganmy
Date: June 14, 2006 08:54AM

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Equivalent for all_catalog
5385
June 14, 2006 08:54AM
2378
June 14, 2006 09:04AM
2890
June 14, 2006 09:25AM
2293
June 14, 2006 11:13AM
2656
June 14, 2006 11:22AM
2380
June 14, 2006 11:31AM
2785
June 14, 2006 11:39AM
2562
June 14, 2006 11:52AM
2482
June 14, 2006 02:04PM
2490
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.