Udostępnij za pośrednictwem

  • Artykuł

UserDefinedTableType Class

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

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Deklaracja
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly)> _
Public NotInheritable Class UserDefinedTableType
    Inherits TableViewTableTypeBase
    Implements ICreatable, IAlterable, IRenamable, IDroppable, _
    IScriptable, IExtendedProperties, IObjectPermission

[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

/** @attribute EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule) */ 
/** @attribute PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly) */ 
public final class UserDefinedTableType extends TableViewTableTypeBase implements ICreatable, IAlterable, 
    IRenamable, IDroppable, IScriptable, IExtendedProperties, IObjectPermission

EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule) 
PhysicalFacetAttribute(PhysicalFacetOptions.ReadOnly) 
public final class UserDefinedTableType extends TableViewTableTypeBase implements ICreatable, IAlterable, 
    IRenamable, IDroppable, IScriptable, IExtendedProperties, IObjectPermission

Remarks

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

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.