-
Notifications
You must be signed in to change notification settings - Fork 0
/
03_row_counts.sql
30 lines (28 loc) · 1.93 KB
/
03_row_counts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SELECT 'tls201_appln Count:', count(*) FROM tls201_appln;
SELECT 'tls202_appln_title Count:', count(*) FROM tls202_appln_title;
-- SELECT 'tls203_appln_abstr Count:', count(*) FROM tls203_appln_abstr;
SELECT 'tls204_appln_prior Count:', count(*) FROM tls204_appln_prior;
SELECT 'tls205_tech_rel Count:', count(*) FROM tls205_tech_rel;
SELECT 'tls206_person Count:', count(*) FROM tls206_person;
SELECT 'tls207_pers_appln Count:', count(*) FROM tls207_pers_appln;
SELECT 'tls209_appln_ipc Count:', count(*) FROM tls209_appln_ipc;
SELECT 'tls210_appln_n_cls Count:', count(*) FROM tls210_appln_n_cls;
SELECT 'tls211_pat_publn Count:', count(*) FROM tls211_pat_publn;
SELECT 'tls212_citation Count:', count(*) FROM tls212_citation;
SELECT 'tls214_npl_publn Count:', count(*) FROM tls214_npl_publn;
SELECT 'tls215_citn_categ Count:', count(*) FROM tls215_citn_categ;
SELECT 'tls216_appln_contn Count:', count(*) FROM tls216_appln_contn;
SELECT 'tls222_appln_jp_class Count:', count(*) FROM tls222_appln_jp_class;
SELECT 'tls224_appln_cpc Count:', count(*) FROM tls224_appln_cpc;
SELECT 'tls225_docdb_fam_cpc Count:', count(*) FROM tls225_docdb_fam_cpc;
SELECT 'tls226_person_orig Count:', count(*) FROM tls226_person_orig;
SELECT 'tls227_pers_publn Count:', count(*) FROM tls227_pers_publn;
SELECT 'tls228_docdb_fam_citn Count:', count(*) FROM tls228_docdb_fam_citn;
SELECT 'tls229_appln_nace2 Count:', count(*) FROM tls229_appln_nace2;
SELECT 'tls230_appln_techn_field Count:', count(*) FROM tls230_appln_techn_field;
SELECT 'tls231_inpadoc_legal_event Count:', count(*) FROM tls231_inpadoc_legal_event;
SELECT 'tls801_country Count:', count(*) FROM tls801_country;
SELECT 'tls803_legal_event_code Count:', count(*) FROM tls803_legal_event_code;
SELECT 'tls901_techn_field_ipc Count:', count(*) FROM tls901_techn_field_ipc;
SELECT 'tls902_ipc_nace2 Count:', count(*) FROM tls902_ipc_nace2;
SELECT 'tls904_nuts Count:', count(*) FROM tls904_nuts;