Data Dictionary and Information Schema

Question

Hi What is the difference between the Oracle Data Dictionary and MySQL's INFORMATION_SCHEMA?

Jimmy Underwood · Answer

Thanks to all

Arjun Panwar · Answer

Hi jimmy Oracle and MySQL provide metadata information in tables. At the detail level though there are many differences because Oracle and MySQL use different table names and column names for that metadata information. There is more similarity with DB2 and SQL Server which also has an INFORMATION_SCHEMA as in the SQL standard.

Datta Kharad · Answer

Hi You can refer this link.. http://www.mysql-rdbms.info/archives/what-is-the-difference-between-the-oracle-data-dictionary-and-mysql-information_schema.html