locked
Table created but not visible RRS feed

  • Question

  • User1515247499 posted

    Hi, Guys I'm having a bit of an issue within my visual studio server explorer. I have been used to creating databases and tables using management studio. I am actually reading an article on how to create the same within visual studio.

    1.The first step, I have created the database connection in Visual Studio.(on the server explorer window)

    2.Next, on the Add Connection dialog. I have set the server name to (localdb)\v11.0 indicating that I want to use the LocalDB feature, checked the Use Windows Authentication option and set the database name to Smothiebar.

    The above steps worked fine and on the visual studio server explorer A new item appears in the Data Connections section of the Server Explorer window, which I can expand to
    see the different facets of the database.

    To create the database table,  I right-click the Tables item for the new Smothiebar database in the Server Explorer window and select Add New Table.

    Visual Studio displays a designer window for creating a new table. I  use the T-SQL section to Enter the SQL statement  and click the Updatebutton in the top-left corner of the table design window. Visual Studio creates a table and I can name and save the table.

    THIS IS WHERE THE PROBLEM IS I CAN NOT VIEW THE TABLE I JUST CREATED.I HAVE CLICKED REFRESH ON THE SERVER EXPLORER WINDOW, BUT STILL NO TABLE, I HAVE CLOSED AND REOPENED VISUAL STUDIO , BUT STILL NO TABLE.

    Can someone please tell me what I'm doing wrong or is this a bug within visual studio?

    Thanks in advance...

    Saturday, December 26, 2015 9:09 PM

Answers

  • User1515247499 posted

    I have actually fixed the problem I was clicking on generate scripts instead of update database.it works fine now.

    thanks to all.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, December 26, 2015 11:26 PM