SystemDataTypeCollection Class
SQL Server 2012
The SystemDataTypeCollection class represents a collection of SystemDataType objects that represent all the system data types on the referenced database.
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.SystemDataTypeCollection
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase
Microsoft.SqlServer.Management.Smo.SystemDataTypeCollection
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The SystemDataTypeCollection type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | Count | Gets the number of objects in the referenced collection. (Inherited from SmoCollectionBase.) |
![]() | IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Inherited from SmoCollectionBase.) |
![]() | Item(Int32) | Gets a SystemDataType object in the collection by index number. |
![]() | Item(String) | Gets a SystemDataType object in the collection by name. |
![]() | Parent | Gets the Server object that is the parent of the SystemDataTypeCollection object. |
![]() | SyncRoot | Gets an object that can be used to synchronize access to the collection. (Inherited from SmoCollectionBase.) |
| Name | Description | |
|---|---|---|
![]() | Add | Adds a system data type to the collection. |
![]() | AddExisting | Adds an object to the collection. (Inherited from AbstractCollectionBase.) |
![]() | Contains | Verifies whether the specified object exists in the collection. (Inherited from SimpleObjectCollectionBase.) |
![]() | CopyTo | Copies the collection of objects to a one-dimensional array starting at the specified index value. |
![]() | Equals | (Inherited from Object.) |
![]() | GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Inherited from SmoCollectionBase.) |
![]() | GetHashCode | (Inherited from Object.) |
![]() | GetType | (Inherited from Object.) |
![]() | ItemById | Extracts a member from the SystemDataTypeCollection collection by using a system-defined, unique identifier. |
![]() | Refresh() | Refreshes the referenced collection. (Inherited from SmoCollectionBase.) |
![]() | Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Inherited from SmoCollectionBase.) |
![]() | ToString | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() | initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from AbstractCollectionBase.) |
| Name | Description | |
|---|---|---|
![]() ![]() | ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Inherited from SmoCollectionBase.) |
An SystemDataTypeCollection object can be used to gain access to a set of system data types. You can use the Item property to return a specific SystemDataType object.

.gif?cs-save-lang=1&cs-lang=jscript)
.gif?cs-save-lang=1&cs-lang=jscript)
.gif?cs-save-lang=1&cs-lang=jscript)
.gif?cs-save-lang=1&cs-lang=jscript)
.gif?cs-save-lang=1&cs-lang=jscript)
.gif?cs-save-lang=1&cs-lang=jscript)