我使用的是sqlparse包,但是我只获得表的别名,您可以在下面找到我的代码:FROM VA_ASSISTES va, datamart_Sales.dbo.Seller f,这就是我现在得到的结果,只有别名:但是,我想像这样检索表名:datamart_Sales.dbo.Seller、datamart_Sales.dbo.
IF OBJECT_ID('DataMart.dbo.tablename_yyyymmdd') IS NOT NULL PRINT 'Student Data load completed' INTO DataMart.dbo.tablename_yyyymmddFROM
( SELECT * FROM [DataMart].
[v_FactMeteredUsageMonthly] as FMUMjoin [AI_DataMart].[v_DimAccount] as A on(FMUM.DimAccountKey = A.DimAccountKey)
Join [AI_DataMart].[AzureViews].[v_FactMeteredUsageMon