What does 'vw' mean in this SQL statement?
sql, sql-view
Solution
It's a View, if you have a read of that link, Microsoft do a good job of explaining what a view is and why someone might use one.
"vw" is a common prefix for a View.
If you expand the "Views" section in SSMS you should see the View call `vwTournamentDetails`.
Here are the views from my AdventureWorks2012 Database:
Problem
What does vw mean in front of TournamentDetails? ``` SELECT * FROM vwTournamentDetails WHERE firstname='@firstName' AND lastname='@lastName' AND --etc ``` Where is the table TournamentDetails coming from? We have no table named TournamentDetails.