Classe UserDefinedTableTypeCollection
The UserDefinedTableTypeCollection class represents a collection of UserDefinedTableType objects that represent all the user-defined table types that are defined on a database.
Hiérarchie d'héritage
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SchemaCollectionBase
Microsoft.SqlServer.Management.Smo.UserDefinedTableTypeCollection
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public NotInheritable Class UserDefinedTableTypeCollection _
Inherits SchemaCollectionBase
'Utilisation
Dim instance As UserDefinedTableTypeCollection
public sealed class UserDefinedTableTypeCollection : SchemaCollectionBase
public ref class UserDefinedTableTypeCollection sealed : public SchemaCollectionBase
[<SealedAttribute>]
type UserDefinedTableTypeCollection =
class
inherit SchemaCollectionBase
end
public final class UserDefinedTableTypeCollection extends SchemaCollectionBase
Le type UserDefinedTableTypeCollection expose les membres suivants.
Propriétés
| Nom | Description | |
|---|---|---|
.gif "Propriété publique") |
Count | Gets the number of objects in the referenced collection. (hérité de SmoCollectionBase.) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (hérité de SmoCollectionBase.) |
|
Item[Int32] | Gets a UserDefinedTableType object in the collection by index number. |
|
Item[String] | Gets a UserDefinedTableType object in the collection by name. |
|
Item[String, String] | Gets a UserDefinedTableType object in the collection by name and schema. |
|
Parent | Gets the Database object that is the parent of the UserDefinedTableType object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. (hérité de SmoCollectionBase.) |
Haut de la page
Méthodes
| Nom | Description | |
|---|---|---|
.gif "Méthode publique") |
Add | Adds the specified UserDefinedTableType object to the collection. |
.gif "Méthode protégée") |
AddExisting | Adds an object to the collection. (hérité de AbstractCollectionBase.) |
|
Contains(String) | Validates whether the parameter collection contains a member with a name equal to the specified string. (hérité de SchemaCollectionBase.) |
|
Contains(String, String) | Validates whether the parameter collection contains a member with a name equal to the specified string and with the specified schema. (hérité de SchemaCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array starting at the index value specified. |
|
Equals | (hérité de Object.) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (hérité de SmoCollectionBase.) |
|
GetHashCode | (hérité de Object.) |
|
GetType | (hérité de Object.) |
|
ItemById | Extracts a member from the UserDefinedTableTypeCollection collection by using a system-defined, unique identifier. |
|
Refresh() | Refreshes the referenced collection. (hérité de SmoCollectionBase.) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (hérité de SmoCollectionBase.) |
|
ToString | (hérité de Object.) |
Haut de la page
Champs
| Nom | Description | |
|---|---|---|
.gif "Champ protégé") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (hérité de AbstractCollectionBase.) |
Haut de la page
Implémentations d'interfaces explicites
| Nom | Description | |
|---|---|---|
.gif "Implémentation d'interface explicite") .gif "Méthode privée") |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (hérité de SmoCollectionBase.) |
Haut de la page
Notes
A UserDefinedTableTypeCollection object can be used to gain access to a set of user-defined table types. You can use the Item property to return a specific UserDefinedTableType object.
Thread Safety
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Exemples
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.