Defined List Types

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Where appropriate, SQL-DMO member functions that return a reference on a SQLObjectList object are implemented to return a reference on a typed list of objects. For example, the ListIndexedColumns member function, that returns an SQLObjectList object enumerating the columns on which a Microsoft® SQL Server™ index is defined, uses the syntax:

HRESULT ListIndexedColumns(LPSQLDMOCOLUMNLIST* ppList);

That the list object returned contains only SQL-DMO Column objects is visible from the function prototype, and for the C/C++ application developer, the typed list forces a specific type recognition and aids in program readability.

SQL-DMO defines the following object list types.

Type SQLObjectList object contains

LPSQLDMODBOBJECTLIST

DBObject objects

LPSQLDMOPERMISSIONLIST

Permission objects

LPSQLDMOCONFIGVALUELIST

ConfigValue objects

LPSQLDMOBACKUPDEVICELIST

BackupDevice objects

LPSQLDMOCOLUMNLIST

Column objects

LPSQLDMOUSERDEFINEDDATATYPELIST

UserDefinedDatatype objects

LPSQLDMOSTOREDPROCEDURELIST

StoredProcedure objects

LPSQLDMOLOGINLIST

Login objects

LPSQLDMOUSERLIST

User objects

LPSQLDMODATABASELIST

Database objects

LPSQLDMOKEYLIST

Key objects