I'm coming from an Oracle background and came across code to create a SQL Server view which I've never seen before.
We have a view called viewA (for example)
Within the script to generate the view I see this code
select columnA, columnB, columnC from tableA as vw_tableB
The question I have is, what is the view really called?
Is it viewA or vw_tableB.
The other question I have is what is the rationale behind this?