What is an alternative way of getting tables in MY-Sql Database?

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

Answer:

We can use information_schema.tables view to get all the tables in specified database.

For Example:-

select table_name as 'Udt Tables' from information_schema.tables

where table_schema = 'db_name';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : When we write more than one columns in a Select st ...

Next > : How to see all the User Defined Tables from specif ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions