SSMS Table in Azure - Design shows <Unknown>

iBlade Tool Intelligence 21 Reputation points
2023-03-08T22:12:09.6233333+00:00

Hi, why is the Table <Unknown> at the Design option. The "*base3" table was created with AzureDataStudio, and the "*base2" with SSMS, both with the same problem.

AzureSSMSProblem

AzureSSMSProblem

Azure SQL Database
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee
    2023-04-10T15:00:31.85+00:00

    @iBlade Tool Intelligence As per the support resolution we have logged a bug internally and we work to get it fixed.

    As a workaround, we suggest not having a period(.) in the database name.

    Thanks for your patience and for reporting this issue to us.

    Thank you for visiting the Microsoft QA forums! Have a great day!

    Regards

    Geetha

    1 person found this answer helpful.
    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Erin Stellato 676 Reputation points Microsoft Employee
    2023-03-28T14:42:26.7166667+00:00

    @iBlade Tool Intelligence Have finally recreated using the following steps:

    1. Create an Azure SQL database that has a period in the name (for example, Customer.Issue)
    2. Create a table in the database (create table test1 (col1 int, col2 varchar(10)))
    3. Right-click on the new table, select Edit Top 200 Rows.
    4. With the edit table window open, select the Show Criteria button.
    5. When the criteria window opens, the table name will show as <Unknown>

    I will log a bug for this internally.

    1 person found this answer helpful.
    0 comments No comments

  2. Alberto Morillo 34,146 Reputation points MVP
    2023-03-09T03:31:56.8433333+00:00

    Please download the latest version of SSMS and Azure Data Studio to have a better user experience. Download SSMS v19 from here.


  3. Erin Stellato 676 Reputation points Microsoft Employee
    2023-03-09T20:13:12.1466667+00:00

    @iBlade Tool Intelligence Hey there - trying to make sure I understand exactly where you are seeing the 'unknown" text for the table. It is in the Database Designer view, is that correct? And you created the tables in SSMS and ADS using T-SQL or using Table Designer? I am trying to understand the steps that you followed and ultimately what designer and window the screenshots are from, but I don't want to assume. I'm happy to log an issue for you internally, once I can recreate it. Thanks!


  4. Erin Stellato 676 Reputation points Microsoft Employee
    2023-05-25T15:03:02.31+00:00

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.