CREATE TABLE tbl1 (
id int not null auto_increment, 
f1 varchar(50) DEFAULT NULL COMMENT 'название',
f2 int(11) NULL COMMENT 'описание',
PRIMARY KEY (id),
) DEFAULT CHARSET=cp1251 COMMENT='пример';

SELECT c.TABLE_NAME,c.COLUMN_NAME, c.COLUMN_COMMENT, c.DATA_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.COLUMN_KEY, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME
FROM information_schema.COLUMNS c
LEFT JOIN information_schema.KEY_COLUMN_USAGE k ON k.COLUMN_NAME=c.COLUMN_NAME and k.table_name = 'имя таблицы'
WHERE c.table_name = 'имя таблицы';