Subscriptions initiate the replication of data or stored procedures. A subscription specifies a table or function replication definition name, or a publication, and the database into which the data is to be replicated.
A subscription for a table replication definition replicates data.
A subscription for a function replication definition replicates stored procedures.
A subscription for a publication replicates the data represented by each article in the publication. Publications can also have articles for stored procedures.
A subscription to a table or function replication definition may include a where clause, which determines the rows that are replicated or whether a stored procedure is replicated.
A subscription to a publication cannot include a where clause. where clauses
are contained in the publication’s articles.
