Article Object Properties Methods Lists Collections
| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| CreationScriptPath String Write: Yes |
The full Universal Naming Convention (UNC) path and filename of the initial synchronization creation script for the article. |
| DeleteCommand String Write: Yes |
The Transact-SQL statement to execute upon delete. If empty, construct the delete from the log. |
| Description String Write: Yes |
A description for the article. |
| DestinationTableName Identifier Write: Yes |
The name of the destination table on the subscribing server. |
| FilterClause String Write: Yes |
The Transact-SQL WHERE clause used to filter the article for horizontal partitioning. |
| ID Long Write: No |
The article ID. |
| InitialSyncObjectName Identifier Write: Yes |
The table or view used to create the initial synchronization output file, if one was manually created. Values written to this property will be ignored when the article has no horizontal or vertical partitioning. |
| InsertCommand String Write: Yes |
The Transact-SQL statement to execute upon insert. If empty, construct the insert from the log. |
| Name Identifier Write: Yes |
The name of the article. |
| Parent Database Write: No |
The Database object. |
| PreCreationMethod SQLOLE_PREARTICLE_TYPE Write: Yes |
The type of command executed on the destination table before synchronization occurs. |
| ReplicateAllColumns Boolean Write: No |
Indicates if all columns of the source table are replicated. If True, all columns of the source table are replicated. If False, the source table has been vertically partitioned and only some columns are replicated. |
| ReplicationFilterProcName Identifier Write: Yes |
The stored procedure that is used to filter the table for horizontal partitioning, if one was manually created. Values written to the property will be ignored if there is no horizontal or vertical filterin. |
| ReplicationType SQLOLE_REPLICATION_TYPE Write: Yes |
The type of replication to use for this article. |
| TableName Identifier Write: Before Add |
The source table being published and replicated. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UpdateCommand String Write: Yes |
The Transact-SQL statement to execute upon update. If empty, construct the update from the log. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |