SDU Tools 157 List User Defined Data Types
SDU Tools are free tools and provide example T-SQL code for SQL Server developers and DBAs. The ListUserDefinedDataTypes procedure returns a list of all user-defined (alias) data types within a database. It also shows their underlying system data type.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com