GetObjectByName Method

SQL-DMO

SQL-DMO

GetObjectByName Method

The GetObjectByName method returns a DBObject object that references the specified Microsoft® SQL Server™ 2000 database object.

Applies To
Database Object
Syntax

object.GetObjectByName( Name , [ ObjectType ] , [ Owner ] ) as DBObject

Parts

object

Expression that evaluates to an object in the Applies To list.

Name

Specifies a SQL Server database object by name.

ObjectType

Optional. Long integer that specifies object type. When specified, it directs method searching, optimizing the search. Set ObjectType using SQLDMO_OBJECT_TYPE.

Owner

Optional. String that identifies an existing database user by name. When specified, it constrains searching to objects owned by the user.

Prototype (C/C++)

HRESULT GetObjectByName(
SQLDMO_LPCSTR szName,
LPSQLDMODBOBJECT* ppDBObject,
SQLDMO_OBJECT_TYPE lType = SQLDMOObj_AllDatabaseObjects,
SQLDMO_LPCSTR szOwner CPPDEFAULT(= NULL));

Returns

A DBObject object