SSDT open table sql file doesn't show designer view

yan huang 6 Reputation points
2022-07-12T20:35:52.943+00:00

when open table sql file from solution explorer, it doesn't show designer view, only show the code view.

When i right click the sql file choose open with ssdt editor selector, it say can't open the file with selected editor

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,414 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Anna Xiu-MSFT 30,821 Reputation points Microsoft Vendor
    2022-07-13T07:49:37.967+00:00

    Hi @yan huang ,

    Which version of Visual Studio are you using?

    Please close all running instances of Visual Studio and update your VS to the latest version.
    Then, create a new project and add a new table.sql file to check if the Table Designer is appeared.

    Meanwhile, you can also repair your VS through Visual Studio Installer > More > Repair.

    If it doesn’t work, please share us some screenshots about the complete error message so that we can investigate it further.

    Sincerely,
    Anna
    *
    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.