Hi,
Is it possible to get a schema file or sql scripts with which I can create the tables for Global and EP databases? Basically all the TLS tables and REG tables, just the table definition without any data.
I have got the schema diagrams from the catalog files and those are very helpful. I am looking to create the empty databases so that I can write my scripts in sql management studio and use sql addins which will provide additional features. I will then copy my scripts and then run them on patstat online databases.
Obviously I can do this myself by using the schema PDF but that will involve a lot of typing. If anyone has already done that or if the sql scripts are available then that will be awesome.
Thanks
Database Schema
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Database Schema
Hi,
Here are the scripts to create the table: They are also part of each delivery of the data.
Best regards,
Martin EPO/PATSTAT
Here are the scripts to create the table: They are also part of each delivery of the data.
Best regards,
Martin EPO/PATSTAT
-
- Posts: 2
- Joined: Wed Aug 28, 2019 11:20 am
Re: Database Schema
Fabulous.
Thanks Martin,
Thanks Martin,