检测Sql-view结构

Question

我创建了这样一个视图

SELECT        dbo.BaharInOut.BCode, dbo.Bahar.BName
FROM            dbo.Bahar INNER JOIN
                     dbo.BaharInOut ON dbo.Bahar.BCode = dbo.BaharInOut.BCode

并试图从msSQL获得信息

1-路1

SELECT        COLUMN_NAME, TABLE_NAME
FROM            INFORMATION_SCHEMA.VIEW_COLUMN_USAGE AS VCU
WHERE        (VIEW_NAME = 'AAA')

答案是

COLUMN_NAME  TABLE_NAME
------------ -------------
BCode        Bahar
BName        Bahar
BCode        BaharInOut

如您所见，BCode是重复的。

2-路2

SELECT Name
        FROM    sys.dm_exec_describe_first_result_set (N'SELECT *   from  AaA ', null, 1) 

结果变得越来越奇怪

Name
--------
BCode
BName
BCode
Serial
MSeq

有什么想法吗？

Answer 1

在Way2中，只需使用"is_hidden“列添加简单的"where”

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