SELECT TABLE_NAME FROM information_schema.tables WHERE table_schema = 'databasename'
SELECT TABLE_NAME, column_name FROM information_schema.columns WHERE TABLE_NAME = 'tablename'