Zend FR

SELECT c.table_schema, c.table_name, c.column_name, c.ordinal_position as column_ordinal_position, c.data_type, c.column_default, c.is_nullable, c.character_octet_length, c.numeric_precision, c.numeric_scale, c.character_set_name, tc.constraint_type, k.ordinal_position as key_ordinal_position 
FROM INFORMATION_SCHEMA.COLUMNS c 
LEFT JOIN (INFORMATION_SCHEMA.KEY_COLUMN_USAGE k 
JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc 
ON (k.table_schema = tc.table_schema AND k.table_name = tc.table_name AND tc.constraint_type = 'PRIMARY KEY')) 
ON (c.table_schema = k.table_schema 
AND c.table_name = k.table_name 
AND c.column_name = k.column_name) 
WHERE c.table_name = 'MA_TABLE'