Total Page Preview:   000000025623

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.
Anton
30-Nov-2019
Quality posts is the main to be a focus for the people to pay a quick visit the website, that's what this website is providing.
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
Schreffler
07-Dec-2019
You need to be a part of a contest for one of the finest blogs on the web. I will recommend this site!
Starke
30-Nov-2019
If you would like to improve your experience just keep visiting this site and be updated with the newest news update posted here.
Franz
24-Nov-2019
Hello to every single one, it's truly a fastidious for me to pay a quick visit this website, it includes valuable Information.
Moritz
24-Nov-2019
It's in fact very complicated in this active life to listen news on Television, thus I just use the web for that reason, and take the newest information.
Parkin
16-Dec-2019
Awesome! Its actually awesome paragraph, I have got much clear idea regarding from this article.
Cotter
24-Nov-2019
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! However, how could we communicate?
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!
Dorrington
24-Nov-2019
It's going to be end of mine day, however before finish I am reading this enormous piece of writing to increase my experience.
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.
Wrixon
21-Nov-2019
Please let me know if you're looking for a article author for your blog. You have some really good posts and I think I would be a good asset. If you ever want to take some of the load off, I'd love to write some material for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Kudos!
Gonsalves
26-Nov-2019
Hi there! I could have sworn I've been to this website before but after reading through some of the post I realized it's new to me. Anyhow, I'm definitely glad I found it and I'll be bookmarking and checking back often!
카지노
09-Dec-2019
If some one wishes expert view regarding blogging and site-building then i recommend him/her to go to see this web site, Keep up the good work.
espn.com/activate
10-Dec-2019
Ask any Search Engine Optimiser, writing a blog post, no matter how good it is, won't bring you any links. Sitting tight after finishing an awesome content is the last thing that you should do, if you want to get high traffic and social shares to the blog post.
Harvill
22-Nov-2019
Hi! I could have sworn I've been to this blog before but after looking at a few of the posts I realized it's new to me. Nonetheless, I'm definitely pleased I came across it and I'll be bookmarking it and checking back regularly!
Easterling
23-Nov-2019
I blog quite often and I genuinely appreciate your content. This article has truly peaked my interest. I will book mark your website and keep checking for new information about once a week. I subscribed to your RSS feed too.
Hammel
24-Nov-2019
hey there and thank you for your info – I have certainly picked up something new from right here. I did however expertise a few technical points using this site, since I experienced to reload the website a lot of times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I'm complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your quality score if ads and marketing with Adwords. Well I'm adding this RSS to my e-mail and could look out for a lot more of your respective interesting content. Ensure that you update this again very soon.
Decker
24-Nov-2019
Greetings from Florida! I'm bored at work so I decided to browse your site on my iphone during lunch break. I really like the information you present here and can't wait to take a look when I get home. I'm surprised at how fast your blog loaded on my phone .. I'm not even using WIFI, just 3G .. Anyways, good blog!
Mcgough
15-Jan-2020
I am regular visitor, how are you everybody? This post posted at this web site is in fact nice.
O'Conor
15-Jan-2020
I was wondering if you ever thought of changing the structure of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?
Patino
15-Jan-2020
Keep on writing, great job!
Lavallee
15-Jan-2020
Wow! This blog looks just like my old one! It's on a entirely different subject but it has pretty much the same layout and design. Great choice of colors!
Marr
15-Jan-2020
If you would like to get a great deal from this paragraph then you have to apply such strategies to your won webpage.
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.
Coney
23-Nov-2019
What's up to every body, it's my first go to see of this webpage; this website contains awesome and really fine information in support of visitors.
Winder
23-Nov-2019
When some one searches for his vital thing, therefore he/she wants to be available that in detail, thus that thing is maintained over here.
Collings
30-Nov-2019
Hi, this weekend is good for me, because this time i am reading this impressive informative paragraph here at my house.
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.
Goodin
20-Nov-2019
Stunning quest there. What occurred after? Thanks!
Breaux
24-Nov-2019
Pretty! This has been an incredibly wonderful article. Thank you for supplying these details.
Frewer
30-Nov-2019
An outstanding share! I have just forwarded this onto a friend who was doing a little research on this. And he actually ordered me lunch simply because I found it for him... lol. So let me reword this.... Thank YOU for the meal!! But yeah, thanx for spending some time to discuss this issue here on your website.
Blackwelder
30-Nov-2019
Hey would you mind stating which blog platform you're working with? I'm planning to start my own blog soon but I'm having a hard time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking for something unique. P.S Sorry for getting off-topic but I had to ask!
Cranford
30-Nov-2019
I absolutely love your blog and find the majority of your post's to be precisely what I'm looking for. Would you offer guest writers to write content for yourself? I wouldn't mind publishing a post or elaborating on a lot of the subjects you write regarding here. Again, awesome blog!
Troup
30-Nov-2019
Hello there! Do you use Twitter? I'd like to follow you if that would be ok. I'm undoubtedly enjoying your blog and look forward to new posts.
Benavides
30-Nov-2019
Hey! Someone in my Myspace group shared this site with us so I came to check it out. I'm definitely enjoying the information. I'm bookmarking and will be tweeting this to my followers! Exceptional blog and great design and style.
Townsend
30-Nov-2019
I think this is one of the most significant information for me. And i'm glad reading your article. But should remark on some general things, The site style is ideal, the articles is really nice : D. Good job, cheers
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.
Howland
30-Nov-2019
Great article, totally what I was looking for.
Applegate
05-Oct-2019
Superleuk informatief artikel met alle highlights opgesomd!
Primm
30-Nov-2019
I feel this is among the most important info for me. And i'm glad studying your article. However should statement on some common issues, The website taste is ideal, the articles is in reality nice : D. Good job, cheers
Mahlum
30-Nov-2019
Have you ever considered creating an ebook or guest authoring on other sites? I have a blog based upon on the same topics you discuss and would really like to have you share some stories/information. I know my viewers would enjoy your work. If you're even remotely interested, feel free to shoot me an email.
Stanfill
30-Nov-2019
That is very interesting, You are an excessively skilled blogger. I have joined your rss feed and look ahead to searching for extra of your great post. Additionally, I've shared your web site in my social networks
Darley
30-Nov-2019
Hello colleagues, how is the whole thing, and what you wish for to say concerning this piece of writing, in my view its truly amazing in favor of me.
Seevers
05-Dec-2019
I wanted to thank you for this great read!! I definitely enjoyed every bit of it. I have you bookmarked to look at new stuff you post…
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!
Elliot
16-Nov-2019
I visited many web sites except the audio feature for audio songs current at this site is truly fabulous.
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 ;)
Marrufo
16-Nov-2019
Hello are using Wordpress for your blog platform? I'm new to the blog world but I'm trying to get started and create my own. Do you require any html coding expertise to make your own blog? Any help would be greatly appreciated!
Tims
21-Nov-2019
Howdy just wanted to give you a brief heads up and let you know a few of the images aren't loading properly. I'm not sure why but I think its a linking issue. I've tried it in two different web browsers and both show the same outcome.

                           
                           

                           

                           

Facebook User: