Collections:
CREATE VIEW - Creating a View on an Existing Table in SQL Server
How To Create a View on an Existing Table in SQL Server?
✍: FYIcenter.com
If you want to a view on an existing table, you can use the CREATE VIEW statement in a simple syntax:
CREATE VIEW view_name AS SELECT ...
The tutorial exercise below shows you how to create a view to represent sub set of data stored in fyi_links table:
USE FyiCenterData; GO CREATE VIEW fyi_links_top AS SELECT id, counts, url FROM fyi_links WHERE counts > 100; GO SELECT TOP 10 * FROM fyi_link_top; GO id counts url ------ ------- ----------------------------------------- 7600 237946 eyfndw jdt lee ztejeyx l q jdh k 19437 222337 eypx u x 55924 1877 eyq ntohxe i rtnlu riwaskzp cucoa dva c 63742 121330 ezdaeh mmgmo vaai meytbjjv f jixfsdjw pw 92455 945262 ezlmyenrw dyeb 36391 41386 f 87433 977726 f 7180 559314 f kqbqlej s xixuurcgg lh r dqqvqsstxw 2252 702033 f bkh jy sqrkttuoarxmfp idqyhyy tme d 1228 146283 f m asukh
⇒ sys.views - List of Existing Views in SQL Server
⇐ What Are Views in SQL Server
2016-11-05, 2518🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...