1SELECT *
2 FROM information_schema.columns
3 WHERE table_schema = 'your_schema'
4 AND table_name = 'your_table'
5 ;
1SELECT column_names
2 FROM information_schema.columns
3 WHERE table_schema = 'your_schema'
4 AND table_name = 'your_table'
5 ;
6-- just for column names