• Article

GetObjectByName Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object.GetObjectByName(Name, [ ObjectType ] , [ Owner ] )asDBObject

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.

Applies To:

Database Object