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.

メモ :
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