declare @v sysName;

declare @v sysname;

DECLARE @1 Int, @2 int, @3 INT -- works fine in a case-sensitive DB
GO
CREATE TYPE MyAwesomeType FROM VARCHAR(30)
GO
DECLARE @1 MyAwesomeType -- works fine
GO
DECLARE @1 myAwesomeType -- fails in a case-sensitive DB
GO
DROP TYPE MyAwesomeType

SELECT name, system_type_id, user_type_id, is_user_defined
FROM sys.types
WHERE name = 'sysname'

-- name       system_type_id user_type_id is_user_defined
-- ---------- -------------- ------------ ---------------
-- sysname    231            256          0