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, 2405🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...