how to create a database table in visual studio 2013

Question

Hi all i created a database in VS2013 as project->add new item-> service based database->name->employee.mdf----add and i open this in solution explorer and opened it as database explorer but when i right click on the table it doesn't shows add new table it shows only refresh and properties my problem is that how to add new table in employee database please reply asap thanks in advance

swati smita · Answer

Hii all I do have the same problem. I am unable to add table. When i right click on the table it showing only refresh and properties. I have newly installed visual studio 2013. if any solution pls reply. Thanks

Hemant Sharma · Answer

Thanks for reply to all @Srikanth: but there is not a issue with connection  instead of that i want to know how to find option for adding tables since i right clicked on the explored employee.mdf's table but it doesn't shows add table(it shows only refresh & blank properties options).

Yadlapalli Srikanth · Answer

1. open server explorer 2. Right click on Dataconnections 3.Select AddConnection and then select Microsoft Sqlserver Database File. 4. Browse the MDF file and add it. 5. Now you can find the MDF as one of the Database you can create table here.

Nimit Joshi · Answer

Hey it may be possible that the SQL Server Data Tools for the Visual Studio 2013 is not installed on your pc. Please install it from the following link: Sql Server Data Tools for Visual Studio 2013

Sumit Jolly · Answer

I don't have VS2013 so can't test. But you can try to open employee.mdf in MS-Access also and add table there. twitter @sumitjolly