How to Get a View Table Query (Code) in SQL Server 2008 Management Studio

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

In Management Studio, open the Object Explorer.

• Go to your database
• There's a subnode Views
• Find your view
• Choose Script view as > Create To > 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'

How do I see the script of a table in SQL Server 2008 Management Studio?

Here's one way:

• Open SSMS
• Open Object Explorer (hit F8)
• Connect to a SQL instance
• Open "Databases"
• Open the desired database
• Open "Tables"
• Right-click on the desire table
• In the menu, select "Script table as"
• In the sub-menu, select "Create to"
• In the sub-sub-menu, select "New Query Editor Window"

This will generate a create script and lod it into its own query window.

Here's more detail than you wanted:

• From the SSMS menu, select Tools / Options
• In the dialog window, select "SQL Server Object Explorer"
• Select "Scripting"

Each of the items in the right-hand pane will control an aspect of how and what objects will be scripted by Object Explorer.

show Create commands for table in SQL Management Studio (2008)

In Object Explorer, expand your server/database, expand Tables, right-click the table in question, and choose Script Table as > CREATE To > New Query Editor Window.

If you want to script multiple tables, you can turn on Object Explorer Details (F7 or from the View menu), highlight "Tables" on the left, then use Shift+ or Ctrl+ to select multiple tables in the right pane (just like you would select multiple files in Windows Explorer). Then you can do the same thing, right-click, Script Table as > ...

View data of a table in sql server 2008

I'm assuming you are trying to view all the records in a table and there are more than 1000? In that case

SELECT * FROM <table name here>

or select the "select top 1000 rows" option and then just remove the "TOP 1000" from the query

How to view the stored procedure code in SQL Server Management Studio

Right click on the stored procedure and select Script Stored Procedure as | CREATE To | New Query Editor Window / Clipboard / File.

You can also do Modify when you right click on the stored procedure.

For multiple procedures at once, click on the Stored Procedures folder, hit F7 to open the Object Explorer Details pane, hold Ctrl and click to select all the ones that you want, and then right click and select Script Stored Procedure as | CREATE To.

How do I get the script to a database view

Select the View in the Object Explorer, right click, and select Script View as -> Create to -> New Query Editor Window. That will create a script to create the view in a new window.

Erick

Where is my view in SQL Server?

In Management Studio please try adding your preferred database name and execute it.

use [yourDatabaseName]

Select * from [dbo].[LAT_POLDATA]

If that gives you an error that view is not in your database

Then follow this

USE [yourDatabasename]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create View [dbo].[LAT_POLDATA] AS (
    SELECT A.sensorId , A.obDate , A.Value 
    FROM [Met].[dbo].[POLDATA] AS A
    INNER JOIN (
        SELECT sensorId , MAX(obDate) AS obDate 
        FROM [Met].[dbo].[POLDATA] 
        GROUP BY sensorId  
    ) AS B
        ON A.sensorId  = B.sensorId 
        AND A.obDate  = B.obDate 
)

GO

How do I view executed queries within SQL Server Management Studio?

Use SQL Profiler and use a filter on it to get the most expensive queries.

---

Related Topics