Inconsistent display of user defined data type on object explorer in ADS (compared to SSMS)

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.

https://learn.microsoft.com/sql/azure-data-studio

MIT License

7.58k stars 903 forks source link

Inconsistent display of user defined data type on object explorer in ADS (compared to SSMS) #11834

Open MsSQLGirl opened 4 years ago

MsSQLGirl commented 4 years ago

Azure Data Studio Version: Version: 1.22.0-insider (user setup) Commit: 3192d056f2d5545089a61f5ef6debd9382bb07c7 Date: 2020-08-17T05:37:23.730Z VS Code: 1.48.0 Electron: 7.3.2 Chrome: 78.0.3904.130 Node.js: 12.8.1 V8: 7.8.279.23-electron.0 OS: Windows_NT x64 10.0.19041

Steps to Reproduce:

Create Azure SQL DB from AdventureWorksLT sample.
Navigate to [SalesLT].[ProductModel] in object explorer.

Azure Data Studio

SSMS:

Expected: consistency. I find SSMS display is more usable here.

kburtram commented 3 years ago

@MsSQLGirl to clarify the issue here, are you referring to the nvarchar not containing the length and the missing XML type? Or something else about the display?