0

I'm trying to create a new table based on an existing table.
In the existing one, there are two columns that are sysname data type.

But when I'm trying to create the new one with sysname, SSMS shows

Invalid data type

pop-up. enter image description here
But this doesn't really make sense to me that if sysname is invalid, why it can be used in the old table?

My SQL Server version is Microsoft SQL Server 2019 (RTM-GDR) (KB5014356) - 15.0.2095.3 (X64)
SSMS version is 15.0.18390.0

0

1 Answer 1

4

The table designer is very limited and has a number of unresolved defects.

Most professionals choose to write T-SQL CREATE TABLE statements instead.

You will have noticed sysname is not available in the drop-down list of type names.

This is probably because it is a synonym (for nvarchar(128)) rather than a base type.

If you want to leave feedback for Microsoft about this, you can do so at https://aka.ms/sqlfeedback

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.