Information about published fields in primary articles includes:
Database server name and database name of the primary database
Owner of the primary object
Name of the primary object
Stored procedure group number (stored procedures only)
Type of the primary object (table or stored procedure)
Field identifier (ordinal position)
Field name (column name or parameter name)
Datatype of the field
Precision of the datatype (precision of numeric datatypes, or length of string or binary datatypes)
Scale of the datatype (numeric datatypes only)
You must qualify a primary article by publication or by primary database when you request published field information.
To get information about published fields in a
specific primary article in a specific publication
Use sp_helpprimaryart with the fields keyword, and specify a primary article name and a publication:
sp_helpprimaryart fields, pri_art, pub=pub_name
where pri_art is the name of the primary article, and pub_name is the name of a publication.
To get information about published fields in a
specific primary article in a specific primary database
Use sp_helpprimaryart with the fields keyword, and specify a primary article name and a primary database connection:
sp_helpprimaryart fields, pri_art, conn="conn_name"
where pri_art is the name of the primary article, and conn_name is the name of a primary database connection.
