SystemDatatypes Collection

SQL-DMO

SQL-DMO

SystemDatatypes Collection

The SystemDatatypes collection contains SystemDatatype objects that enumerate the base data types of an instance of Microsoft® SQL Server™.

Properties
Count Property  
Methods
Item Method  

Remarks

SQL Server defines a fixed number of base data types. Because the number is fixed, the SystemDatatypes collection, representing those data types, has fixed membership and does not support the Add or Remove methods.

When using the Item method, the SystemDatatypes collection supports member identification using either name or ordinal reference syntax. For example:

Set oSystemDatatype = oSQLServer.SystemDatatypes("ntext")

Or:

Set oSystemDatatype = oSQLServer.SystemDatatypes(7)