How can I open and view *.NDF files?

Question

I am trying to open and view several *.NDF files. Please let me know the easiest way to do this in MS Azure.

Answer 1

An NDF data file is a secondary data file and a secondary data file exists always associated with a primary data file (.mdf file).

Using a tool like SQL Server Management Studio (SSMS) you can open a .NDF file by attaching the whole database it belongs to including its associated primary data file. However, you cannot view secondary data files directly in SSMS without attaching its associated .mdf file also