如何在SQL Server中获取特定查询中使用的表的列表？

-- 查询要分析的查询文本
DECLARE @query_text NVARCHAR(MAX)
SET @query_text = 'SELECT * FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID'

-- 获取查询的执行计划和统计信息
DECLARE @plan_handle VARBINARY(64)
SELECT @plan_handle = qs.plan_handle
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
WHERE st.text = @query_text

-- 获取查询的执行计划
SELECT *
FROM sys.dm_exec_query_plan(@plan_handle)

-- 解析查询文本，获取使用的表的列表
DECLARE @table_list TABLE (TableName NVARCHAR(128))
DECLARE @table_name NVARCHAR(128)
DECLARE @start_pos INT, @end_pos INT

SET @start_pos = CHARINDEX('FROM', @query_text) + 5
SET @end_pos = CHARINDEX('JOIN', @query_text)

WHILE @start_pos > 0 AND @end_pos > 0
BEGIN
    SET @table_name = SUBSTRING(@query_text, @start_pos, @end_pos - @start_pos)
    INSERT INTO @table_list (TableName) VALUES (@table_name)

    SET @start_pos = CHARINDEX('FROM', @query_text, @end_pos) + 5
    SET @end_pos = CHARINDEX('JOIN', @query_text, @start_pos)
END

-- 查询每个表的详细信息
SELECT *
FROM sys.tables t
WHERE t.name IN (SELECT TableName FROM @table_list)