Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Cannot save a view/function/procedure that is self-referenced.
Collapse the table of content
Expand the table of content

Cannot save a view/function/procedure that is self-referenced.

Views, functions, and stored procedures cannot reference themselves directly or indirectly. For example, if you have a view named titleview, you cannot insert SQL syntax such as SELECT * from titleview.

  1. Remove the self-referencing SQL syntax.

    –or-

  2. Create a new view/function/procedure by using the Save As command.

Community Additions

ADD
Show:
© 2015 Microsoft