Database Schema

[vishwasrathi]

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

[EPO / PATSTAT Support]

Hi,

Here are the scripts to create the table:

PATSTAT_CreateScripts_2019Spring.zip

(57.29 KiB) Downloaded 1180 times

They are also part of each delivery of the data.

Best regards,
Martin EPO/PATSTAT

[vishwasrathi]

Fabulous.

Thanks Martin,