EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation


A User-Defined Data Type is internally represented as an existing type, but is considered to be a separate data type. In fact, this is an alias data type in an instance of SQL Server, a CLR data type, or a table data type (for SQL Server 2008). An alias data type's implementation is based on a SQL Server native system type. A user-defined type is implemented through a class of an assembly in the Microsoft .NET Framework common language runtime (CLR).



UDT Editor allows you to define user-defined type properties. It opens automatically when you create a new type and is available on editing an existing one.


To open a user-defined type in UDT Editor, double-click it in the DB Explorer tree.