get views

get-views.tsql

declare @tsql varchar(max) = 'SELECT 
               a.code, b.customer_name
           FROM table_a a 
           INNER JOIN table_b b ON a.code = b.code
           WHERE NOT EXISTS (SELECT 1
                             FROM table_c c
                             WHERE a.code = c.code)'

exec ('create view vwtmp as ' + @tsql)

select OBJECT_NAME(referencing_id) referencing_entity,
        o.[type_desc] as referenced_entity_type, referenced_entity_name
from sys.sql_expression_dependencies d
inner join sys.objects o
    on d.referenced_id = o.[object_id]
where OBJECT_NAME(referencing_id) = 'vwtmp'

exec ('drop view vwtmp')