TSQLScriptDomParserでのSQLからのテーブル列挙のためのxpathまとめ

句	xpath
selectのfrom	//node[@class='FromClause']/children[@type='TableReferences']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
selectのjoin	//node[@class='QualifiedJoin']/children[@type='FirstTableReference' or @type='SecondTableReference']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
insert	//node[@class='InsertSpecification']/children[@type='Target']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
update	//node[@class='UpdateSpecification']/children[@type='Target']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
delete	//node[@class='DeleteSpecification']/children[@type='Target']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
merge	//node[@class='MergeSpecification']/children[@type='Target']/node[@class='NamedTableReference']/children[@type='SchemaObject']/node[@class='SchemaObjectName']
truncate	//node[@class='TruncateTableStatement']/children[@type='TableName']/node[@class='SchemaObjectName']
select into	//node[@class='SelectStatement']/children[@type='Into']/node[@class='SchemaObjectName']
bulk insert	//node[@class='BulkInsertStatement']/children[@type='To']/node[@class='SchemaObjectName']

• 出力の解釈

項目	値
サーバ名	/node/children[@type='ServerIdentifier']/node のvalue属性
データベース名	/node/children[@type='DatabaseIdentifier']/node のvalue属性
スキーマ名	/node/children[@type='SchemaIdentifier']/node のvalue属性
テーブル名	/node/children[@type='BaseIdentifier']/node のvalue属性