search

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.54k stars 899 forks source link

Sysname not recognized as data type #20346

Open tdoshin opened 2 years ago

tdoshin commented 2 years ago

Steps to Reproduce:

  1. Open new table in Table Designer
  2. In the "Type" field, select the drop down and search for "sysname" data type

Expected:

User should be able to find this data type

Actual:

User is not able to find this data type right away. They have to scroll to the bottom of the list against alphabetical order and sysname is denoted as "sys.sysname"

Impact: Since the data types are listed in alphabetical order, user may be led to believe that this data type is not supported

Does this issue occur when all extensions are disabled?: Yes/No

erinstellato-ms commented 2 years ago

This exists in the dropdown as sys.sysname - it doesn't appear "alphabetically" in the list.