Skip to main content



      Home
Home » Eclipse Projects » DTP » Any way to implement DDL parser(Parse create,alter and drop statements)
Any way to implement DDL parser [message #552461] Thu, 12 August 2010 05:58 Go to next message
Eclipse UserFriend
I need to parse DDL statements like create,alter and drop and extract all the field and their datatype info in each tables . I found that DTP model base project only parses select query and other related statements. So can i really do this using model base project? or some other library
Brian Payton who have commented about parsers in other threads can help me with this
Re: Any way to implement DDL parser [message #552523 is a reply to message #552461] Thu, 12 August 2010 09:32 Go to previous message
Eclipse UserFriend
Hi,

we are using ANTLR for this purpose. I have two grammar files those are doing stuff like this. One is the grammar of the Ingres Database System and another one is derived from MySQL's grammar and was created for the purpose to migrate Procedures from MySQL to Ingres. Here are the links to them:

* http://code.ingres.com/apps/IngresMigrationToolSet/IngresPar serCollectionLib/trunk/src/com/ingres/antlr/sql/resources/In gresSQL.g

* http://code.ingres.com/apps/IngresMigrationToolSet/IngresPar serCollectionLib/trunk/src/com/ingres/antlr/idiom/resources/ mysql/MySQLASTGen.g

I hope this is helpful for you.

Regards, David
Previous Topic:what is this ?
Next Topic:Any way to implement DDL parser
Goto Forum:
  


Current Time: Wed Jul 23 18:42:57 EDT 2025

Powered by FUDForum. Page generated in 0.04024 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top