ListObjectNames Method
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The ListObjectNames method returns a NameList object that enumerates a specified type of database object involved in the schema and/or data copy operation defined by the Transfer object used.
語法
object
.ListObjectNames(
ObjectType
)
as
NameList
Parts
object
Expression that evaluates to an object in the Applies To list.ObjectType
Long integer that constrains list membership by database object type as described in Settings.
Prototype (C/C++)
HRESULT ListObjectNames(
SQLDMO_OBJECT_TYPE ObjectType,
LPSQLDMONAMELIST* ppList);
Settings
Use the SQLDMO_OBJECT_TYPE values defined below when setting the ObjectType argument. Specify only a single database object type.
Constant |
Value |
Description |
|---|---|---|
SQLDMOObj_/AllButSystemObjects |
5119 |
Returned SQLObjectList object enumerates all but Microsoft SQL Server system objects. |
SQLDMOObj_/AllDatabaseObjects |
4607 |
Returned SQLObjectList object enumerates SQL Server system and user database objects. |
SQLDMOObj_/AllDatabaseUserObjects |
4605 |
Returned SQLObjectList object enumerates only user database objects. |
SQLDMOObj_Default |
64 |
Returned SQLObjectList object enumerates SQL Server defaults. |
SQLDMOObj_Rule |
128 |
Returned SQLObjectList object enumerates SQL Server rules. |
SQLDMOObj_StoredProcedure |
16 |
Returned SQLObjectList object enumerates SQL Server stored procedures. |
SQLDMOObj_SystemTable |
2 |
Returned SQLObjectList object enumerates SQL Server system tables. |
SQLDMOObj_Trigger |
256 |
Returned SQLObjectList object enumerates SQL Server triggers. |
SQLDMOObj_/UserDefinedDatatype |
4096 |
Returned SQLObjectList object enumerates SQL Server user-defined data type. |
SQLDMOObj_/UserDefinedFunction |
1 |
Returned SQLObjectList object enumerates user-defined function. |
SQLDMOObj_UserTable |
8 |
Returned SQLObjectList object enumerates SQL Server user-defined tables. |
SQLDMOObj_View |
4 |
Returned SQLObjectList object enumerates SQL Server views. |
Returns
A NameList object that enumerates database objects by name.