Collections:
sys.sql_modules - Getting View Definitions Back in SQL Server
How To Get the Definition of a View Out of the SQL Server in SQL Server?
✍: FYIcenter.com
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 definitions 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.views:
USE FyiCenterData; GO SELECT m.definition FROM sys.sql_modules m, sys.views v WHERE m.object_id = v.object_id AND v.name = 'fyi_links_top'; GO definition ------------------------------------------- CREATE VIEW fyi_links_top (LinkText) AS SELECT CONVERT(VARCHAR(20),id) + ' - ' + CONVERT(VARCHAR(20),counts) + ' - ' + url FROM fyi_links WHERE counts > 1000 (1 row(s) affected)
⇒ Creating a View with Data from Multiple Tables in SQL Server
⇐ Generating CREATE VIEW Scripts on Existing Views in SQL Server
2016-11-05, 1992🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...