Sql-server – Does NOLOCK on Views propagate to the underlying tables

lockingsql-server

If you include a NOLOCK hint on a select from a VIEW, does that NOLOCK hint propagate down into the tables joined within the view? If not, what's the purpose of locking a view?

Sample view code:

CREATE VIEW [my_custom_view]
AS
  SELECT
    a1.[column_a], a1.[column_b], a1.[column_c], a1.[column_d]
  FROM
    [table_a] a1
    JOIN [table_b] b1 ON b1.[column_a] = a1.[column_b]

And the NOLOCK statement:

SELECT 
  [column_a], [column_b]
FROM
  [my_custom_view] NOLOCK
Related Question