Detect Sql-view Structure

I create a view like this SELECT dbo.BaharInOut.BCode, dbo.Bahar.BName FROM dbo.Bahar INNER JOIN dbo.BaharInOut ON dbo.Bahar.BCode = dbo.Baha

Solution 1:

In Way2 just add simple "where" by using "is_hidden" column

SELECT Name,source_column,source_table FROM sys.dm_exec_describe_first_result_set (N'SELECT * from AAA', null, 1) WHERE is_hidden=0