SELECT column_name , data_type , COLUMN_COMMENT FROM INFORMATION_SCHEMA .COLUMNS WHERE table_name = '表名' AND table_schema = '数据库名'