MySQL Query to get names of all Tables in Database

Last Reply on Nov 24, 2013 11:41 PM By Pradip

Posted on Nov 24, 2013 06:44 PM

MySql query to get all table names of a database in asp.net

Posted on Nov 24, 2013 11:41 PM

Try This

 

SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='test';