Collections:
Generating CREATE VIEW Scripts on Existing Views in SQL Server
How To Generate CREATE VIEW Script on an Existing View in SQL Server?
✍: FYIcenter.com
If you want to know how an existing view was created, you can use SQL Server Management Studio to automatically generate a "CREATE VIEW" script The following tutorial shows you how to do this:
1. Run SQL Server Management Studio and connect to SQL server.
2. On the Object Explorer window, follow the object tree: Databases > FyiCenterData > Views > dbo.fyi_links_top.
3. Click right mouse button on dbo.fyi_links_top. The context menu shows up.
4. Select "Script Table as" > "CREATE to" > "New Query Editor Window". The following script will be displayed:
USE [FyiCenterData] GO /****** Object: View [dbo].[fyi_links_top] Script Date: 05/19/2007 15:07:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[fyi_links_top] AS SELECT id, counts, url FROM fyi_links WHERE counts > 100;
⇒ sys.sql_modules - Getting View Definitions Back in SQL Server
⇐ "sp_help" - Getting a List of Columns in a View in SQL Server
2016-11-05, 3184🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...