SELECT attribute, type FROM eav_attribute WHERE entity_type_id = x AND attribute_code = 'name';

SELECT attribute_code, backend_type FROM eav_attribute WHERE entity_type_id = x AND attribute_code = 'name';

SELECT attribute_code, type FROM eav_attribute WHERE entity_type_id = x AND attribute_code = 'name';

SELECT attribute_code, type FROM attribute WHERE entity = x AND attribute = 'name';