asp.netsql-servermdfldf

how can i see data in mdf file

i have asp.net application. it has App_Data folder. this folder contain mdf and ldf file. how can i see data within these file. i want to see table structure.

Solution

  • Using SQL Server Management Studio Express you can attach that file.

    How to attach a file

    However, if you are viewing that in a project in Visual Studio, you can see that in the server explorer.

    Also, here is a similar question on the asp.net forums.