Indexed View Article Properties, General Tab
After you create indexed views, they will appear as objects in the Create Publication Wizard in the Specify Articles dialog box.
When you replicate these objects, the definitions are replicated as part of the initial snapshot applied at the Subscriber. Subsequent changes to the definition of these objects are not copied automatically to Subscribers. However, replicating the definition of these objects can provide a convenient mechanism for deploying these components of your application to Subscribers.
When publishing indexed views that are not schema-only articles for snapshot replication or transactional replication, you do not have to replicate the view as a table. When the view is published to the Subscriber, a table is created on the Subscriber that contains the data the view is based upon. Indexing a view as a table at a Subscriber can be a convenient way of replicating the contents of a view without requiring that each of the tables that comprise the view definition are replicated as well.
Any objects referenced by the indexed view (such as tables or functions) should also be published or should be created manually at each Subscriber.
The following options are available on the General tab of the Indexed View Article Properties dialog box.
Options
Name
If creating a new indexed view article, enter the name of the article. If the article is already created, view the name of the article.
Source View Owner
View the owner for the indexed view to be published.
Source View Name
View the name of the indexed view to be published.
Destination View Owner
Enter or view the owner of the replicated object after it is published to the Subscriber.
Destination View Name
View the name of the replicated object after it is published to the Subscriber.
Description
Enter a description for the indexed view article.
In snapshot and transactional publications that do not allow updatable subscriptions, you can specify whether indexed view articles create an indexed view or a table at the Subscriber. Indexed view articles in merge publications always create an indexed view at the Subscriber.
An indexed view
Create an indexed view at the Subscriber. This option is not displayed for merge publications.
A table defined by the source indexed view
Create a table at the Subscriber containing the data at the Publisher defined by the indexed view. This option is not displayed for merge publications.