How to get a view table query code in SQL Server 2008 Management Studio

Question

I have a view in SQL Server 2008 and would like to view it in Management Studio   Example   --is the underlying query for the view Example 1 select    from table aView    View name  Example 1  How to get the query of the corresponding view table  query used to create the view    Thanks in advance

User · Answer

Use sp helptext before the view name  Example   sp helptext Example 1   Hence you will get the query   CREATE VIEW dbo Example 1 AS SELECT       a  b  c FROM         dbo table name JOIN blah blah blah WHERE        blah blah blah   sp helptext will give stored procedures

User · Answer

if i understood you can do the following  Right Click on View Name in SQL Server Management Studio -  Script View As - CREATE To - New Query Window

User · Answer

Additionally  if you have restricted access to the database  IE  Can t use  Script Function as   CREATE To    there is another option to get this query   Find your View   right click    Design    This will give you the query you are looking for

User · Answer

In Management Studio  open the Object Explorer    Go to your database There s a subnode Views Find your view Choose Script view as  gt  Create To  gt  New query window    and you re done     If you want to retrieve the SQL statement that defines the view from T-SQL code  use this   SELECT       m definition     FROM sys views v INNER JOIN sys sql modules m ON m object id   v object id WHERE name    Example 1

User · Answer

right-click the view in the object-explorer  select  script view as      then  create to  and then  new query editor window

[sql] How to get a view table query (code) in SQL Server 2008 Management Studio

Examples related to sql

Examples related to sql-server

Examples related to view