且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

解析SQL查询并拉出列名和表名

更新时间:2023-02-26 10:46:42

我认为***的答案是使用 Irony 解析器:http://irony.codeplex.com/

I think the best answer is going to be to use the Irony parser: http://irony.codeplex.com/

Hanselman 有一个关于如何使用它来解析 SQL 的很好的链接:http://www.hanselman.com/blog/TheWeeklySourceCode59AnOpenSourceTreasureIronyNETLanguageImplementation

Hanselman has a great link to how to use it to parse SQL: http://www.hanselman.com/blog/TheWeeklySourceCode59AnOpenSourceTreasureIronyNETLanguageImplementationKit.aspx

我希望这会有所帮助,祝你好运!

I hope this helps, and best of luck!