Online Documentation for SQL Manager for SQL server
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.
- Using Navigation bar and Toolbar
- Creating/editing user-defined type
- Managing UDT checks
- Managing UDT Primary/Unique Keys
- Browsing object dependencies
- Editing user-defined type description
- Viewing DDL definition
- Setting object permissions