Changing SQL Express Table Table Name

Question

Hi, I am using Visual Studio 2008, and I have .mdf in the app_data of my ASP.NET MVC project. I tried to change the name of the table through the properties in the server explorer, but it is greyed out. Can I change the name?

I see that you can copy the table, but I'm not sure how to paste it into it somewhere?

Thanks for any help.

Answer 1

Double-click the .mdf file. Then it will open in Server Explorer. Right-click the table and select "Open Table Definition". Then open the Properties window - the first property is (Name) - change it and save the table - What is it!