I want to find the columns in a database which are of a particular user
defined data type.

Is the following query correct for this purpose?

SELECT SO.NAME, SC.NAME, ST.NAME
FROM SYSOBJECTS SO
INNER JOIN Syscolumns SC ON SC.ID = SO.ID
INNER JOIN Systypes ST ON ST.usertype = SC.usertype
where ST.NAME LIKE 'DROPDOWN'


Thanks in advance for your reply.