The SystemDatatypes collection contains SystemDatatype objects enumerating the base data types of a Microsoft® SQL Server™ installation.
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)