Compartir a través de

  • Artículo

UserDefinedTableType Clase

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class UserDefinedTableType _
    Inherits TableViewTableTypeBase _
    Implements ICreatable, IAlterable, IRenamable, IDroppable,  _
    IScriptable, IExtendedProperties, IObjectPermission
'Uso
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

Notas

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Seguridad para subprocesos

Todos los miembros públicos static (Shared en Visual Basic) de este tipo son seguros para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.