how can i see data in mdf file.

Question

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.

Answer 1

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.

Answer 2

See How to: Attach a Database (SQL Server Management Studio).