SSMS Table in Azure - Design shows <Unknown>

iBlade Tool Intelligence 21

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

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-03-08T23:55:30.0433333+00:00

Hi, @iBlade Tool Intelligence Welcome to the Microsoft Q&A forum, Thanks for posting your question.

Can you please confirm if you’re trying to use a query designer connected to Azure SQL Database?

Regards

Geetha
iBlade Tool Intelligence 21 Reputation points

2023-03-09T10:15:59.35+00:00

Accepted answer

GeethaThatipatri-MSFT 29,477 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
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

4 additional answers

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-28T14:42:26.7166667+00:00
@iBlade Tool Intelligence Have finally recreated using the following steps:

Create an Azure SQL database that has a period in the name (for example, Customer.Issue)

Create a table in the database (create table test1 (col1 int, col2 varchar(10)))

Right-click on the new table, select Edit Top 200 Rows.

With the edit table window open, select the Show Criteria button.

When the criteria window opens, the table name will show as <Unknown>

I will log a bug for this internally.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Alberto Morillo 34,056 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.
Please sign in to rate this answer.
iBlade Tool Intelligence 21 Reputation points

2023-03-09T12:48:05.5366667+00:00

It worked for the table, now comes the view:

Alberto Morillo 34,056 Reputation points MVP

2023-03-09T16:55:36.4966667+00:00

Please report it as a bug on this Web site. Happy to hear your original issue with SSMS Table Designer was solved.

iBlade Tool Intelligence 21 Reputation points

2023-03-09T18:14:33.05+00:00

Hi Alberto, I've posted some comment there, but it is not possible to add images, what makes the explanation very complicated ... Year 2023 and a support website does not have image support...

Alberto Morillo 34,056 Reputation points MVP

2023-03-09T19:24:09.68+00:00

Please try to use imgur to upload the image to that web site and then share the link to the image on your explanation of the SSMS bug.

Alberto Morillo 34,056 Reputation points MVP

2023-03-14T00:18:30.6866667+00:00

Geetha is waiting for you to send her an email with the requested information.

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-14T02:15:18.44+00:00

Hey all - I spoke with @iBlade Tool Intelligence and the issue is not with SSMS, it is specific to the database. I suggested opening a support issue, as this is not something we are able to troubleshoot easily, and I could not reproduce it.

Alberto Morillo 34,056 Reputation points MVP

2023-03-14T03:59:38.1+00:00

Thank you Erin for the update.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Erin Stellato 656 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!
Please sign in to rate this answer.
iBlade Tool Intelligence 21 Reputation points

2023-03-09T22:04:01.7633333+00:00

Hi Erin, I'll try to elucidate you as best as possible.

Originally the database was created in a VM machine with MSSQL+SSMS 2 years ago, then some months ago I've exported it with data to Azure serverless database with the AzureDataStudio. Since that moment that I'm facing the problem when I try to look up things. All started when I tried to change some Views, I start to see the "fx" note in the relation line. I've decided contact Microsoft because I cannot deal with it anymore, currently I need to make the query in my local machine and then paste the sql into the View in Azure.

Because of your inquiry I've started the hole example process again in the database

All the operations are made only with SSMS19

Created 2 tables " _testMaster" *and " _*testDetail":

I'm trying now to Add some lines with the option "Edit Top 200 rows"

Now, even with the SSMS19 I'm getting the <Unknown> but I can still add some rows in the grid.

Now I'm creating a View, all looks normal

Save, Refresh SSMS, Right-Click + Design and this is the result: The SQL is the same, but the relation is crazy and the table has <Unknown> This is the View CREATE TO option (RightClick), all looks completely normal

CREATE VIEW [dbo].[_testView] AS SELECT dbo._testMaster.ID, dbo._testMaster.Name, dbo._testDetail.Descr FROM dbo._testDetail RIGHT OUTER JOIN dbo._testMaster ON dbo._testDetail.MasterID = dbo._testMaster.ID GO

I do not know how can I explain this better... Maybe we need to make some screen sharing and I can show you live...

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-09T22:11:00.7833333+00:00

@iBlade Tool Intelligence This is a really good information, thanks for the additional detail. I'd like to start here "I've exported it with data to Azure serverless database with the AzureDataStudio". Can you tell me how you did that? Did you do a migration through the Migration extension, or did you use SQLProjects? Or something else? Thanks!

iBlade Tool Intelligence 21 Reputation points

2023-03-09T22:28:45.5766667+00:00

This was a while ago, at that time I've tried several things. Earlier I was thinking that was with AzureDataStudio Extension, but now I'm more sure that was with SSMS, AzureDataStudio I took knowledge of it out later.

Sorry, I've tried so many things at that time, that database when was "local" had FILESTREAM and was crazy to sync it to Azure, because of the lack of that feature. I had to change stored procedures, the "Archive" table, ...

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-09T23:15:50.8566667+00:00

@iBlade Tool Intelligence I am not able to recreate what you're seeing, based on the information you have provided above. We can do a 15 minute screen share, if you are able to walk through that. Or you can record a video of what you're doing and share it (e.g. via OneDrive). Let me know what is better for you.

iBlade Tool Intelligence 21 Reputation points

2023-03-09T23:30:32.21+00:00

Yes, lets make a live, it will be better, please send me your contact to this user email. We can make it with TeamViewer, Microsoft Teams, or other app...

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-10T00:12:22.08+00:00

@iBlade Tool Intelligence I don't have access to your email. You can reach me at firstnamelastname at microsoft dot com. firstnamelastname is all one word, no space or period in between.

iBlade Tool Intelligence 21 Reputation points

2023-03-10T00:53:01.5466667+00:00

Hi Erin, at 1:17 I've sent you an email ... Did you received it?

Erin Stellato 656 Reputation points Microsoft Employee

2023-03-10T00:55:55.6566667+00:00

Found your email, sent you an invite for Teams.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Erin Stellato 656 Reputation points Microsoft Employee

2023-05-25T15:03:02.31+00:00

@iBlade Tool Intelligence This has been fixed in SSMS 19.1 https://learn.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms
Please sign in to rate this answer.
fmpt 0 Reputation points

2023-06-05T12:48:00.2766667+00:00

Hi Erin, still not working ... just to confirm that the problem is that the database name has a "."

Erin Stellato 656 Reputation points Microsoft Employee

2023-06-05T13:40:11.3466667+00:00

@iBlade Tool Intelligence If you had a previous version of 19.x installed, can you please try uninstalling SSMS entirely (through add/remove programs) and then reinstall and try again please? Thanks.

fmpt 0 Reputation points

2023-06-05T16:09:37.91+00:00

IT IS WORKING :)... Thanks a lot for the interest and help Erin.

Views are also working, do not show anymore the "fx" in the connection lines

Erin Stellato 656 Reputation points Microsoft Employee

2023-06-05T16:42:01.6966667+00:00

@iBlade Tool Intelligence thanks for verifying, glad both are resolved!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSMS Table in Azure - Design shows <Unknown>

4 additional answers

Your answer