Thursday, October 19th, 2017

Find All Tables and Schema in ORACLE and MYSQL

0

Get All Tables in a Oracle and MySql Schema

Oracle

In Oracle you can use the following query

select object_name from user_objects where object_type = ‘TABLE’;

MYSQL

In MySql you can use the follwing query

show tables;

Get All Schema in Oracle and MySql

ORACLE

We can get all oracle schemas using the following query

SELECT username FROM all_users;
or
SELECT * all_users;

MYSQL

We can get all mysql schemas using the following query

SELECT SCHEMA_NAME FROM information_schema.SCHEMATA;
or
SELECT * information_schema.SCHEMATA;
or
show databases

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • LinkedIn
  • RSS
  • Technorati
  • Twitter

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Secure Linux Web Hosting