Total Page Preview:   000000021044

How to get List names of all tables in SQL Server , MySQL and Oracle

Get name of all tables from database in SQL SERVER, MYSQL and Oracle .
 

SQL SERVER :-

SELECT * FROM sys.Tables

or

SELECT name AS 'Table Name' FROM sys.Tables

or

SELECT * FROM INFORMATION_SCHEMA.TABLES
 

OUTPUT:

 

 

My-SQL:-

SELECT * FROM information_schema.tables WHERE table_type = 'BASE TABLE';
 

information_schema.tables has following columns which one can use to get all required information

TABLE_SCHEMA:

This column store name of db schema or in general database name.

TBALE_NAME

This column stores table name along with db schema name in that row.

TABLE_TYPE

This column contains table type name like system view, view or base table.

Other columns many be useful for purposes.
 

 

OUTPUT :

 

 

Oracle :-

There are three different virtual views you can query to get a list of all available tables. Depending you the permissions you've got, you might not be able to query all of them. If one doesn't work, try the next one.

This query returns a complete list of tables:

 


SELECT owner, table_name FROM dba_tables;
In case you can't access this view, try this:

SELECT owner, table_name FROM all_tables;
If it still doesn't work, try this, but note that this will return a list of table owned by the current user, not all tables in the database:

SELECT table_name FROM user_tables
 

  Thanks!

 

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

Reynoso
23-Sep-2019
Leuk stukje over turkije ik zal het even delen.
Eberhardt
11-Oct-2019
At this moment I am ready to do my breakfast, when having my breakfast coming yet again to read more news.
McAuley
20-Jul-2019
What's up everyone, it's my first visit at this web page, and article is actually fruitful in favor of me, keep up posting these articles or reviews.
Freehill
28-Mar-2019
I’m not that much of a online reader to be honest but your blogs really nice, keep it up! I'll go ahead and bookmark your site to come back later. Cheers
Cartwright
12-Jul-2019
you are really a good webmaster. The website loading speed is incredible. It kind of feels that you are doing any distinctive trick. Furthermore, The contents are masterwork. you've done a fantastic process on this topic!
Orsini
13-Aug-2019
I am not sure where you are getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for wonderful info I was looking for this information for my mission.
Albertson
18-Aug-2019
I think this is among the most important info for me. And i'm glad reading your article. But should remark on some general things, The website style is perfect, the articles is really great : D. Good job, cheers
Lonon
18-Aug-2019
Hi there, I read your new stuff daily. Your story-telling style is witty, keep up the good work!
Caraway
26-Sep-2019
Keep oon writing, great job!
Fennescey
24-Oct-2019
I all the time used to study paragraph in news papers but now as I am a user of internet so from now I am using net for articles, thanks to web.
Barreras
21-Oct-2019
It's the best time to make some plans for the future and it is time to be happy. I've read this submit and if I may just I desire to recommend you some attention-grabbing things or advice. Maybe you can write subsequent articles regarding this article. I want to learn even more issues approximately it!
Snodgrass
12-Nov-2019
If you would like to improve your knowledge simply keep visiting this web site and be updated with the most up-to-date news update posted here.
Feint
04-Nov-2019
These are really fantastic ideas in on the topic of blogging. You have touched some nice points here. Any way keep up wrinting.
Sapp
26-Sep-2019
Hel?o There. I found your bl?g using msn. This is a very we?l written article. I will mame sure to bookm?rk it and come back to read mo?e of your useful info. Thanks for the post. I'll ce?tainly comeback.
Applegate
05-Oct-2019
Superleuk informatief artikel met alle highlights opgesomd!
Upchurch
07-Nov-2019
Have you ever thought about adding a little bit more than just your articles? I mean, what you say is fundamental and everything. But imagine if you added some great visuals or videos to give your posts more, "pop"! Your content is excellent but with pics and clips, this website could undeniably be one of the greatest in its field. Excellent blog!
Bautista
12-Nov-2019
Its such as you learn my thoughts! You seem to know a lot about this, like you wrote the e-book in it or something. I feel that you just can do with a few percent to drive the message house a little bit, but instead of that, that is wonderful blog. A fantastic read. I'll certainly be back.
Heitmann
13-Nov-2019
I'd like to thank you for the efforts you've put in penning this blog. I really hope to check out the same high-grade blog posts by you in the future as well. In fact, your creative writing abilities has encouraged me to get my own, personal website now ;)

                           
                           

                           

                           

Facebook User: