The ListObjectNames method returns a NameList object enumerating 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
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| ObjectType | Long integer constraining list membership by database object type as described in Settings |
Use the values defined below when setting the ObjectType argument. Specify only a single database object type.
| Constant | Value | Description |
|---|---|---|
| SQLDMOObj_Default | 64 | List enumerates default objects |
| SQLDMOObj_Rule | 128 | List enumerates rule objects |
| SQLDMOObj_StoredProcedure | 16 | List enumerates stored procedures |
| SQLDMOObj_Trigger | 256 | List enumerates triggers |
| SQLDMOObj_ UserDefinedDatatype |
1 | List enumerates user-defined data types |
| SQLDMOObj_UserTable | 8 | List enumerates user-defined tables |
| SQLDMOObj_View | 4 | List enumerates views |
A NameList object enumerating database objects by name.
HRESULT ListObjectNames(
SQLDMO_OBJECT_TYPE ObjectType,
LPSQLDMONAMELIST* ppList);