Статья
09/28/2010

Класс UserDefinedTableType

The UserDefinedTableType object represents a SQL Server user-defined table type data type.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class UserDefinedTableType _
    Inherits TableViewTableTypeBase _
    Implements ICreatable, IAlterable, IRenamable, IDroppable,  _
    IScriptable, IExtendedProperties, IObjectPermission
'Применение
Dim instance As UserDefinedTableType

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)]
public sealed class UserDefinedTableType : TableViewTableTypeBase, 
    ICreatable, IAlterable, IRenamable, IDroppable, IScriptable, 
    IExtendedProperties, IObjectPermission

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute(PhysicalFacetOptions::ReadOnly)]
public ref class UserDefinedTableType sealed : public TableViewTableTypeBase, 
    ICreatable, IAlterable, IRenamable, IDroppable, IScriptable, 
    IExtendedProperties, IObjectPermission

[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)>]
type UserDefinedTableType =  
    class
        inherit TableViewTableTypeBase
        interface ICreatable
        interface IAlterable
        interface IRenamable
        interface IDroppable
        interface IScriptable
        interface IExtendedProperties
        interface IObjectPermission
    end

public final class UserDefinedTableType extends TableViewTableTypeBase implements ICreatable, IAlterable, IRenamable, IDroppable, IScriptable, IExtendedProperties, IObjectPermission

Замечания

To get UserDefinedTableType object permissions, users can be a member of the public fixed server role.

To set UserDefinedTableType object permissions, users must have CREATE TYPE permissions in the parent database and ALTER permissions on specified schema. If an assembly is specified, users must either own the assembly or have REFERENCES permissions on it.

To create a user-defined table type data type, users must have CREATE TYPE permissions in the parent database and ALTER permissions on specified schema

To drop a user-defined table type data type, users must have CONTROL permissions on the type and ALTER permissions on the specified schema.

Thread Safety

Все общие статические члены этого типа (Shared в Microsoft Visual Basic) можно использовать в многопоточных операциях. Безопасная многопоточная работа с членами экземпляров типа не гарантируется.