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: 390 | 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 

Comments or Responses

Login to post response