다음을 통해 공유

DBObject Object

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The DBObject object represents properties of a Microsoft SQL Server database object, such as a table or stored procedure.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Properties

CreateDate Property

SystemObject Property

ID Property

Type Property (DBObject)

Name Property

TypeName Property

Owner Property (Database Objects)

 

Methods

EnumDependencies Method

Remove Method (Objects)

ListPermissions Method

Script Method

ListUserPermissions Method

 

주의

The DBObject object is used as a parameter to the GetObjectByName method of the Database object and the AddObject method of the Transfer object.

You can use the DBObject object to refer to SQL Server defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.

With the DBObject object, you can:

  • Query a database by object name to determine whether the specified object exists.
  • Add a list of SQL Server database objects to a script transferring objects and data from one SQL Server database to another.
  • Determine the dependencies on a named SQL Server database object.
  • List the permissions granted on a named SQL Server database object.

The Name property of the DBObject object refers to the name of the selected Database object. Database object names are defined with the SQL Server data type sysname, and the value of the Name property of the DBObject matches the specification of sysname.