I want to create a report listing:

- all tables and views created in a script

- all the used tables and views in a script

for each script file we use to create the databases. Probably 50-80 scripts and around 40K LOC.

My first approach is to parse the script file and extract the names from the create statements and the from clauses. Maybe there's a better way?