Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How To Get the Definition of a View Out of the SQL Server?

April 26, 2017definition SQL Server view

0

Posted

How To Get the Definition of a View Out of the SQL Server?

2 Answers

0

Posted

If you want get the definition of an existing view back from the SQL Server, you can use the system view called sys.sql_modules, which stores defitions of views and procedures. The sys.sql_modules holds view definitions identifiable by the object id of each view. The tutorial exercise below shows you how to retrieve the definition of view, “fyi_link_view” by joining sys.sql_modules and sys.

0

Posted

If you want get the definition of an existing view back from the SQL Server, you can use the system view called sys.sql_modules, which stores defitions of views and procedures. The sys.sql_modules holds view definitions identifiable by the object id of each view.