How do I change the " user-defined data type " ower to dbo?

Data | data type
Method 1. Delete First, then re-establish
if exists (SELECT * from dbo.systypes where name = N ' Dt_ac_area ')
EXEC sp_droptype N ' ssn '
Go
SETUSER--The default is dbo
Go
EXEC sp_addtypen ' Dt_ac_area ', n ' char (3) ', n ' not null '
Go

Method 2. Delete SRX User Defined Data Types directly through the database all mountains:
Use master
Go
EXEC sp_configure ' allow updates ', ' 1 '
Go
Reconfigure with OVERRIDE
Go
Use T--database name
Go
BEGIN TRANSACTION
Delete systypes where uid=user_id (' SRX ')
If @ @rowcount <>0
Commit TRANSACTION
Else
ROLLBACK TRANSACTION
Go
Use master
Go
EXEC sp_configure ' allow updates ', ' 1 '
Go
Reconfigure with OVERRIDE
Go


Also forget that if you don't want to delete, you can update the DBO directly with the second method:

Use master
Go
EXEC sp_configure ' allow updates ', ' 1 '
Go
Reconfigure with OVERRIDE
Go
Use T--database name
Go
BEGIN TRANSACTION
Update systypes SET uid=1 where uid=user_id (' SRX ')--Update directly
If @ @rowcount <>0
Commit TRANSACTION
Else
ROLLBACK TRANSACTION
Go
Use master
Go
EXEC sp_configure ' allow updates ', ' 1 '
Go
Reconfigure with OVERRIDE
Go