Export (0) Print
Expand All
Expand Minimize

Indexed View Article Properties, General Tab

SQL Server 2000

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 an indexed view as a table 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 each of the tables that comprise the view definition to be replicated as well.

When publishing indexed views that are schema-only articles, 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.

See Also

Publishing Data and Database Objects

Show:
© 2014 Microsoft