SQL-DMO

ListObjectNames Method

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.

Applies To
Transfer Object

Syntax

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™ 2000 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.