Alias data types must be created by using create type before they can be used in a table definition 别名数据类型必须先使用create type进行创建,然后才能在表定义中使用。
Alias data types are created with the create type statement before they can be used in a table definition 必须先用create type语句创建别名数据类型,然后才能将其用于表定义中。
Grant create type permission to the users and alter permission for the users on the target schema 创建别名数据类型,请将create type权限授予用户并将alter权限授予目标架构上的用户。
Udts can contain multiple elements and can have behaviors , differentiating them from the traditional alias data types which consist of a single sql server system data type Udt可以包含多个元素并且可以具有多种行为,这将它们与由单个sql server系统数据类型组成的传统别名数据类型区分开来。
If any columns in the alter table statement are defined to be of a common language runtime user - defined type or alias data type , references permission on the type is required 如果将alter table语句中的任何列定义为公共语言运行时( clr )用户定义类型或别名数据类型,都需要对该类型有references权限。
Udts can contain multiple data types and can have behaviors , differentiating them from the traditional alias data types that consist of a single sql server system data type Udt可以包含多种数据类型,也可以具有多种行为,这一点使它与传统的由单个sql server系统数据类型组成的别名数据类型区分开来。
To change the collation of a user - defined alias data type column , you must execute separate alter table statements to change the column to a sql server system data type and change its collation , and then change the column back to an alias data type 的列的排序规则。若要更改用户定义别名数据类型列的排序规则,必须执行单独的alter table语句,将列更改为sql server系统数据类型,并更改其排序规则,然后重新将列更改为别名数据类型。