Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between the Oracle Data Dictionary and MySQLs INFORMATION_SCHEMA?

April 26, 2017Data dictionary information_schema MySQL Oracle

0

Posted

What is the difference between the Oracle Data Dictionary and MySQLs INFORMATION_SCHEMA?

1 Answer

0

Posted

Both Oracle and MySQL provide metadata in tables. However, Oracle and MySQL use different table names and column names. MySQL’s implementation is more similar to those found in DB2 and SQL Server, which also support INFORMATION_SCHEMA as defined in the SQL standard.