Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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.


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

Community Additions

© 2015 Microsoft