Fetch table column

General SQL Parser is a Java/.NET library. It provides a rich set of APIs to parse, decode, analyze and rewrite SQL scripts. Supports more than 10 major database platforms.

Extract table column information from complex SQL scripts is a powerful feature provided by this SQL parser library. By using this SQL parser libray, it is quite easy to list all table and column relationships, table action mode(select/update/delete/insert/merge) and column location(select list/where clause/join condition) in sql scripts.

SQL can be nested inside stored procedure. There is no need connect to a database instance to get all table and column references as long as the SQL itself is not ambiguous. With provided metadata information, this tool can determine relationship of table and column even if SQL is ambiguous.

Please click here to check more detailed information.

Any questions? Feel free to submit your request here.