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';

 

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html