共用方式為


Remove Method (Objects)

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The Remove method drops the referenced database, agent, or replication object from an instance of Microsoft SQL Server connected to, and removes the SQL Distributed Management Objects (SQL-DMO) object from its containing collection.

語法

object
.Remove(
)

Parts

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

Prototype (C/C++)

HRESULT Remove();

備註

For more information about using the Remove method of a SQL-DMO object, including information on privilege required, see documentation for the object or its containing collection.

ms132966.note(zh-tw,SQL.90).gif附註:
If an application calls Remove with the TransPublication object after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.

Applies To:

Alert Object

Login Object

BackupDevice Object

MergeArticle Object

Category Object

MergeDynamicSnapshotJob Object

Check Object

MergePublication Object

Column Object

MergePullSubscription Object

Database Object

MergeSubscription Object

DatabaseRole Object

MergeSubsetFilter Object

DBFile Object

RegisteredServer Object

DBObject Object

RegisteredSubscriber Object

Default Object

RemoteLogin Object

DistributionArticle Object

RemoteServer Object

DistributionDatabase Object

Rule Object

DistributionPublication Object

ServerGroup Object

DistributionPublisher Object

StoredProcedure Object

DistributionSubscription Object

Table Object

DRIDefault Object

TargetServerGroup Object

FileGroup Object

TransArticle Object

FullTextCatalog Object

TransPublication Object

Index Object

TransPullSubscription Object

Job Object

TransSubscription Object

JobSchedule Object

Trigger Object

JobStep Object

User Object

Key Object

UserDefinedDatatype Object

LinkedServer Object

UserDefinedFunction Object

LinkedServerLogin Object

View Object