Get all tables names from a database using a single query

SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE'

Post a Comment