Cannot delete SQL Server User Defined Data Type; Cannot drop type 'dbo.xxx' because it is currently in use.
Problem
You got the following error message when you tried to delete a user defined data type in SQL Server.
You also got a empty list when you view the dependencies.
Msg 3732, Level 16, State 1, Line 3
Cannot drop type 'dbo.xxx' because it is currently in use.
Solution
You need to find out all dependent objects and change them. Here is the sql script.
SELECT o.name as 'Table', c.name as 'Column'
FROM sys.columns c
Join sys.objects o On o.object_id = c.object_id
Join sys.types t On t.user_type_id = c.user_type_id
Where t.name = 'your_type'
Navigator
Other Knowledgebase Articles
Basic SQL Hosting
# of Domains:
4
# of SQL Server Databases:
4
Disk Space:
50GB
Bandwidth:
Unmetered
SQL Server 2016
Monthly:
$4.99
Express Hyper-V Hosting
Dedicated Memory:
2GB
Disk Space:
120GB
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$11.99
Dedicated SQL Server
CPU:
Quad-Core X3440 CPU
RAM:
16GB RAM
Disk:
2x120GB SSD + 300GB SATA
RAID:
RAID 1
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$79.00