Tech Off Thread

2 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

sql Filtering

Back to Forum: Tech Off
  • User profile image
    manojT

    Hi,

     

    I have a sql file which contains the ddl + dml + dcl statements.

    I want to extract only ddl from this file and want to create a file only with extracted ddl.

    Anybody know where I can find the code.

  • User profile image
    blowdart

    manojT wrote:
    

    Hi,

     

    I have a sql file which contains the ddl + dml + dcl statements.

    I want to extract only ddl from this file and want to create a file only with extracted ddl.

    Anybody know where I can find the code.



    Hmm, surely you should be able to parse it, looking for the DDL keywords? A simple text file open, read line by line, and grab those beginning with the right keywords would do it.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.