Contains a row for each article defined in the local database. This table is stored in the published database.
Column name | Data type | Description |
---|---|---|
artid | int | Identity column that provides a unique ID number for the article. |
columns | varbinary(32) | Columns in the tables that are being published. |
creation_script | nvarchar(255) | Schema script for the article. |
del_cmd | nvarchar(255) | Command to execute upon DELETE; otherwise, construct from the log. |
description | nvarchar(255) | Descriptive entry for the article. |
dest_table | sysname | Name of the destination table. |
filter | int | Stored procedure ID, used for horizontal partitioning. |
filter_clause | ntext | WHERE clause of the article, used for horizontal filtering. |
ins_cmd | nvarchar(255) | Command to execute upon INSERT; otherwise, construct from the log. |
name | sysname | Name associated with the article, unique within the publication. |
objid | int | Published table object ID. |
pubid | int | ID of the publication to which the article belongs. |
pre_creation_cmd | tinyint | Pre-creation command for DROP TABLE, DELETE TABLE, or TRUNCATE: 0 = None 1 = DROP 2 = DELETE 3 = TRUNCATE |
status | tinyint | Bitmask of the article options. status is tinyint, and can be one of these values: 0 = No additional properties. 8 = Include the column name in INSERT statements. 16 (default) = Use parameterized statements. 24 = Both include the column name in INSERT statements and use parameterized statements. |
sync_objid | int | ID of the table or view that represents the article definition. |
type | tinyint | Type of article: 1 = Log-based article 3 = Log-based article with manual filter 5 = Log-based article with manual view 7 = Log-based article with manual filter and manual view |
upd_cmd | nvarchar(255) | Command to execute upon UPDATE; otherwise, construct from the log. |
schema_option | binary(8) | Indicates what is to be scripted out. |
dest_owner | sysname | Owner of the table at the destination database. |