We are bulding a new M2 Shop and I need to get all Attributes from our M184.108.40.206 using SQL. The Attribute Options are no problem.
So far I found this code which works great but it only has a few values.
select * from eav_attribute where entity_type_id IN (select entity_type_id from eav_entity_type where entity_type_code = 'catalog_product')
It seams that the "Shop Options" (maybe wrong translation) are missing like (Use in Quick search, Use in Advanced Search, Comparable in Shop, use in Filternav, Use for promo...) M2 has simular options which are called "Storefront Properties".