How to see all the tables(UDT) from within all DB in My-SQL database?

Posted by vishalneeraj-24503 on 6/16/2014 | Category: Sql Server Interview questions | Views: 1399 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

MySQL DB has Show Tables in-build command which extracts all the table from all the Databases.
It's very simple to see all the User Defined Tables.

For Example:-

Show Tables;

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to see all the User Defined Tables from specif ...

Next > : What is the difference between below queries? Sel ...

Comments or Responses

More Interview Questions by vishalneeraj-24503

What is the difference between below queries? Select * from table_nam ...
How to replace a column value with specified value if column value is ...
What is the best way to see all columns in a table?
What do we mean by .class Selector?
What do we mean by element or control Selector?
What do we mean by #id Selector?
How to hide all controls which have the same class applied?
How to hide particular control using jQuery?

Latest Interview Questions

In a Cricket Game, Two Batsman playing each on 94* . They need 7 runs ...
A 6-Feet taller Man found dead by Hanging himself to the Fan in an Emp ...
There are some Apples to the Apple tree. After a strong wind on the tr ...
In MVC is mandatory to be Map route {controller}/{action}/{id} In Thi ...
There is a new building having 100 rooms in it. A painter was hired to ...
Which of the following type of encoding is used in WCF?
Which of the following is the End point component of WCF?
In WCF, the namespaces used for serialization is?
More ...