Asterisk (*) may not be used in an indexed view.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Asterisk (*) may not be used in an indexed view.

Because an indexed view is stored on disk, the view definition must explicitly refer to the columns to be included in the view. Replace the asterisk with the columns you want to include in the view.

Show:
© 2016 Microsoft