Can i open a sdf file to see data?

can i open the sdf file by attaching database in sql server?

if yes does express support to attach database? if not then which one does

SDF files are for Compact SQL. A single user database engine.
SQL Express cannot use SDF files as the file structure is different, you need to convert them to SQL format.

so will i be able to open with sql enterprise or management studio

SDF files can only work with Compact SQL.
SQL Express files will work with any edition of SQL Server as long as it’s the same version or newer.
Why would you want to pay for SQL Server when SQL Express works just as well?

i wont be payng juz gettng 2 yr license