Article Properties

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.