Defined List Types
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
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 |