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, 3043🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...