SELECT table_name FROM information_schema.tables; #### SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_database' AND table_name = 'your_table';