#
source:
mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll
@
8064

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/mauRepo/xmi2sqlalchemy/trunk/src/test/resources/removeAll@8064
Revision 8064, 21.4 KB checked in by mnagni, 8 years ago (diff) |
---|

Line | |
---|---|

1 | SELECT |

2 | 'DROP TABLE IF EXISTS '||c.relname ||' CASCADE;' |

3 | FROM pg_catalog.pg_class c |

4 | JOIN pg_catalog.pg_roles r ON r.oid = c.relowner |

5 | LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace |

6 | WHERE c.relkind IN ('r','') |

7 | AND n.nspname NOT IN ('pg_catalog', 'pg_toast') |

8 | AND pg_catalog.pg_table_is_visible(c.oid) |

9 | ORDER BY 1; |

10 | |

11 | SELECT |

12 | 'DROP SEQUENCE IF EXISTS '||c.relname ||' CASCADE;' |

13 | FROM pg_catalog.pg_class c |

14 | JOIN pg_catalog.pg_roles r ON r.oid = c.relowner |

15 | LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace |

16 | WHERE c.relkind IN ('S','') |

17 | AND n.nspname NOT IN ('pg_catalog', 'pg_toast') |

18 | AND pg_catalog.pg_table_is_visible(c.oid) |

19 | ORDER BY 1; |

20 | |

21 | "DROP SEQUENCE IF EXISTS any_id_seq CASCADE;" |

22 | "DROP SEQUENCE IF EXISTS cc_concatenatedoperation_id_seq CASCADE;" |

23 | "DROP SEQUENCE IF EXISTS cc_conversion_id_seq CASCADE;" |

24 | "DROP SEQUENCE IF EXISTS cc_coordinateoperation_id_seq CASCADE;" |

25 | "DROP SEQUENCE IF EXISTS cc_formula_id_seq CASCADE;" |

26 | "DROP SEQUENCE IF EXISTS cc_generaloperationparameter_id_seq CASCADE;" |

27 | "DROP SEQUENCE IF EXISTS cc_generalparametervalue_id_seq CASCADE;" |

28 | "DROP SEQUENCE IF EXISTS cc_operationmethod_id_seq CASCADE;" |

29 | "DROP SEQUENCE IF EXISTS cc_operationparametergroup_id_seq CASCADE;" |

30 | "DROP SEQUENCE IF EXISTS cc_parametervaluegroup_id_seq CASCADE;" |

31 | "DROP SEQUENCE IF EXISTS cc_passthroughoperation_id_seq CASCADE;" |

32 | "DROP SEQUENCE IF EXISTS cc_singleoperation_id_seq CASCADE;" |

33 | "DROP SEQUENCE IF EXISTS cd_datum_id_seq CASCADE;" |

34 | "DROP SEQUENCE IF EXISTS cd_verticaldatum_id_seq CASCADE;" |

35 | "DROP SEQUENCE IF EXISTS ceda_acquisition_id_seq CASCADE;" |

36 | "DROP SEQUENCE IF EXISTS ceda_citation_id_seq CASCADE;" |

37 | "DROP SEQUENCE IF EXISTS ceda_compositeprocess_id_seq CASCADE;" |

38 | "DROP SEQUENCE IF EXISTS ceda_instrument_id_seq CASCADE;" |

39 | "DROP SEQUENCE IF EXISTS ceda_notes_id_seq CASCADE;" |

40 | "DROP SEQUENCE IF EXISTS ceda_observationcollection_id_seq CASCADE;" |

41 | "DROP SEQUENCE IF EXISTS ceda_observation_id_seq CASCADE;" |

42 | "DROP SEQUENCE IF EXISTS ceda_operation_id_seq CASCADE;" |

43 | "DROP SEQUENCE IF EXISTS ceda_platform_id_seq CASCADE;" |

44 | "DROP SEQUENCE IF EXISTS ceda_process_id_seq CASCADE;" |

45 | "DROP SEQUENCE IF EXISTS ceda_processing_id_seq CASCADE;" |

46 | "DROP SEQUENCE IF EXISTS ceda_project_id_seq CASCADE;" |

47 | "DROP SEQUENCE IF EXISTS ceda_result_id_seq CASCADE;" |

48 | "DROP SEQUENCE IF EXISTS ceda_review_id_seq CASCADE;" |

49 | "DROP SEQUENCE IF EXISTS ci_address_id_seq CASCADE;" |

50 | "DROP SEQUENCE IF EXISTS ci_citation_id_seq CASCADE;" |

51 | "DROP SEQUENCE IF EXISTS ci_contact_id_seq CASCADE;" |

52 | "DROP SEQUENCE IF EXISTS ci_date_id_seq CASCADE;" |

53 | "DROP SEQUENCE IF EXISTS ci_individual_id_seq CASCADE;" |

54 | "DROP SEQUENCE IF EXISTS ci_onlineresource_id_seq CASCADE;" |

55 | "DROP SEQUENCE IF EXISTS ci_organisation_id_seq CASCADE;" |

56 | "DROP SEQUENCE IF EXISTS ci_party_id_seq CASCADE;" |

57 | "DROP SEQUENCE IF EXISTS ci_responsibility_id_seq CASCADE;" |

58 | "DROP SEQUENCE IF EXISTS ci_responsibleparty_id_seq CASCADE;" |

59 | "DROP SEQUENCE IF EXISTS ci_responsiblepartyinfo_id_seq CASCADE;" |

60 | "DROP SEQUENCE IF EXISTS ci_series_id_seq CASCADE;" |

61 | "DROP SEQUENCE IF EXISTS ci_telephone_id_seq CASCADE;" |

62 | "DROP SEQUENCE IF EXISTS class13_0_id_seq CASCADE;" |

63 | "DROP SEQUENCE IF EXISTS class13_1_id_seq CASCADE;" |

64 | "DROP SEQUENCE IF EXISTS class13_2_id_seq CASCADE;" |

65 | "DROP SEQUENCE IF EXISTS class13_3_id_seq CASCADE;" |

66 | "DROP SEQUENCE IF EXISTS cl_dataset_id_seq CASCADE;" |

67 | "DROP SEQUENCE IF EXISTS clocktime_id_seq CASCADE;" |

68 | "DROP SEQUENCE IF EXISTS cs_coordinatesystemaxis_id_seq CASCADE;" |

69 | "DROP SEQUENCE IF EXISTS cs_coordinatesystem_id_seq CASCADE;" |

70 | "DROP SEQUENCE IF EXISTS cs_verticalcs_id_seq CASCADE;" |

71 | "DROP SEQUENCE IF EXISTS cv_attributevalues_id_seq CASCADE;" |

72 | "DROP SEQUENCE IF EXISTS cv_coverage_id_seq CASCADE;" |

73 | "DROP SEQUENCE IF EXISTS cv_domainobject_id_seq CASCADE;" |

74 | "DROP SEQUENCE IF EXISTS cv_footprint_id_seq CASCADE;" |

75 | "DROP SEQUENCE IF EXISTS cv_gridcell_id_seq CASCADE;" |

76 | "DROP SEQUENCE IF EXISTS cv_gridcoordinate_id_seq CASCADE;" |

77 | "DROP SEQUENCE IF EXISTS cv_gridenvelope_id_seq CASCADE;" |

78 | "DROP SEQUENCE IF EXISTS cv_grid_id_seq CASCADE;" |

79 | "DROP SEQUENCE IF EXISTS cv_gridpoint_id_seq CASCADE;" |

80 | "DROP SEQUENCE IF EXISTS cv_referenceablegrid_id_seq CASCADE;" |

81 | "DROP SEQUENCE IF EXISTS date_id_seq CASCADE;" |

82 | "DROP SEQUENCE IF EXISTS dateprecision_id_seq CASCADE;" |

83 | "DROP SEQUENCE IF EXISTS datetime_id_seq CASCADE;" |

84 | "DROP SEQUENCE IF EXISTS directposition_id_seq CASCADE;" |

85 | "DROP SEQUENCE IF EXISTS distance_id_seq CASCADE;" |

86 | "DROP SEQUENCE IF EXISTS dq_dataquality_id_seq CASCADE;" |

87 | "DROP SEQUENCE IF EXISTS dq_element_id_seq CASCADE;" |

88 | "DROP SEQUENCE IF EXISTS dq_positionalaccuracy_id_seq CASCADE;" |

89 | "DROP SEQUENCE IF EXISTS dq_result_id_seq CASCADE;" |

90 | "DROP SEQUENCE IF EXISTS dq_scope_id_seq CASCADE;" |

91 | "DROP SEQUENCE IF EXISTS ds_aggregate_id_seq CASCADE;" |

92 | "DROP SEQUENCE IF EXISTS ds_dataset_id_seq CASCADE;" |

93 | "DROP SEQUENCE IF EXISTS earootclass_id_seq CASCADE;" |

94 | "DROP SEQUENCE IF EXISTS ex_extent_id_seq CASCADE;" |

95 | "DROP SEQUENCE IF EXISTS ex_geographicdescription_id_seq CASCADE;" |

96 | "DROP SEQUENCE IF EXISTS ex_geographicextent_id_seq CASCADE;" |

97 | "DROP SEQUENCE IF EXISTS ex_temporalextent_id_seq CASCADE;" |

98 | "DROP SEQUENCE IF EXISTS ex_verticalextent_id_seq CASCADE;" |

99 | "DROP SEQUENCE IF EXISTS genericname_id_seq CASCADE;" |

100 | "DROP SEQUENCE IF EXISTS gf_associationrole_id_seq CASCADE;" |

101 | "DROP SEQUENCE IF EXISTS gf_associationtype_id_seq CASCADE;" |

102 | "DROP SEQUENCE IF EXISTS gf_attributetype_id_seq CASCADE;" |

103 | "DROP SEQUENCE IF EXISTS gf_constraint_id_seq CASCADE;" |

104 | "DROP SEQUENCE IF EXISTS gf_featuretype_id_seq CASCADE;" |

105 | "DROP SEQUENCE IF EXISTS gfi_feature_id_seq CASCADE;" |

106 | "DROP SEQUENCE IF EXISTS gf_inheritancerelation_id_seq CASCADE;" |

107 | "DROP SEQUENCE IF EXISTS gf_operation_id_seq CASCADE;" |

108 | "DROP SEQUENCE IF EXISTS gf_propertytype_id_seq CASCADE;" |

109 | "DROP SEQUENCE IF EXISTS gm_complex_id_seq CASCADE;" |

110 | "DROP SEQUENCE IF EXISTS gm_composite_id_seq CASCADE;" |

111 | "DROP SEQUENCE IF EXISTS gm_compositepoint_id_seq CASCADE;" |

112 | "DROP SEQUENCE IF EXISTS gm_object_id_seq CASCADE;" |

113 | "DROP SEQUENCE IF EXISTS gm_orientableprimitive_id_seq CASCADE;" |

114 | "DROP SEQUENCE IF EXISTS gm_point_id_seq CASCADE;" |

115 | "DROP SEQUENCE IF EXISTS gm_primitive_id_seq CASCADE;" |

116 | "DROP SEQUENCE IF EXISTS io_identifiedobjectbase_id_seq CASCADE;" |

117 | "DROP SEQUENCE IF EXISTS io_identifiedobject_id_seq CASCADE;" |

118 | "DROP SEQUENCE IF EXISTS le_algorithm_id_seq CASCADE;" |

119 | "DROP SEQUENCE IF EXISTS length_id_seq CASCADE;" |

120 | "DROP SEQUENCE IF EXISTS le_nominalresolution_id_seq CASCADE;" |

121 | "DROP SEQUENCE IF EXISTS le_source_id_seq CASCADE;" |

122 | "DROP SEQUENCE IF EXISTS li_lineage_id_seq CASCADE;" |

123 | "DROP SEQUENCE IF EXISTS li_processstep_id_seq CASCADE;" |

124 | "DROP SEQUENCE IF EXISTS li_source_id_seq CASCADE;" |

125 | "DROP SEQUENCE IF EXISTS localname_id_seq CASCADE;" |

126 | "DROP SEQUENCE IF EXISTS md_aggregateinformation_id_seq CASCADE;" |

127 | "DROP SEQUENCE IF EXISTS md_applicationschemainformation_id_seq CASCADE;" |

128 | "DROP SEQUENCE IF EXISTS md_browsegraphic_id_seq CASCADE;" |

129 | "DROP SEQUENCE IF EXISTS md_constraints_id_seq CASCADE;" |

130 | "DROP SEQUENCE IF EXISTS md_contentinformation_id_seq CASCADE;" |

131 | "DROP SEQUENCE IF EXISTS md_digitaltransferoptions_id_seq CASCADE;" |

132 | "DROP SEQUENCE IF EXISTS md_distribution_id_seq CASCADE;" |

133 | "DROP SEQUENCE IF EXISTS md_distributor_id_seq CASCADE;" |

134 | "DROP SEQUENCE IF EXISTS md_extendedelementinformation_id_seq CASCADE;" |

135 | "DROP SEQUENCE IF EXISTS md_format_id_seq CASCADE;" |

136 | "DROP SEQUENCE IF EXISTS md_identification_id_seq CASCADE;" |

137 | "DROP SEQUENCE IF EXISTS md_identifier_id_seq CASCADE;" |

138 | "DROP SEQUENCE IF EXISTS md_keywords_id_seq CASCADE;" |

139 | "DROP SEQUENCE IF EXISTS md_maintenanceinformation_id_seq CASCADE;" |

140 | "DROP SEQUENCE IF EXISTS md_medium_id_seq CASCADE;" |

141 | "DROP SEQUENCE IF EXISTS md_metadataextensioninformation_id_seq CASCADE;" |

142 | "DROP SEQUENCE IF EXISTS md_metadata_id_seq CASCADE;" |

143 | "DROP SEQUENCE IF EXISTS md_portrayalcataloguereference_id_seq CASCADE;" |

144 | "DROP SEQUENCE IF EXISTS md_referencesystem_id_seq CASCADE;" |

145 | "DROP SEQUENCE IF EXISTS md_representativefraction_id_seq CASCADE;" |

146 | "DROP SEQUENCE IF EXISTS md_scopedescription_id_seq CASCADE;" |

147 | "DROP SEQUENCE IF EXISTS md_spatialrepresentation_id_seq CASCADE;" |

148 | "DROP SEQUENCE IF EXISTS md_standardorderprocess_id_seq CASCADE;" |

149 | "DROP SEQUENCE IF EXISTS md_usage_id_seq CASCADE;" |

150 | "DROP SEQUENCE IF EXISTS measure_id_seq CASCADE;" |

151 | "DROP SEQUENCE IF EXISTS mo_acquisition_id_seq CASCADE;" |

152 | "DROP SEQUENCE IF EXISTS mo_compositeprocess_id_seq CASCADE;" |

153 | "DROP SEQUENCE IF EXISTS mo_computation_id_seq CASCADE;" |

154 | "DROP SEQUENCE IF EXISTS mo_inputoutput_id_seq CASCADE;" |

155 | "DROP SEQUENCE IF EXISTS mo_instrument_id_seq CASCADE;" |

156 | "DROP SEQUENCE IF EXISTS mo_instrumentplatformpair_id_seq CASCADE;" |

157 | "DROP SEQUENCE IF EXISTS mo_location_id_seq CASCADE;" |

158 | "DROP SEQUENCE IF EXISTS mo_observationcollection_id_seq CASCADE;" |

159 | "DROP SEQUENCE IF EXISTS mo_observation_id_seq CASCADE;" |

160 | "DROP SEQUENCE IF EXISTS mo_onlineresource_id_seq CASCADE;" |

161 | "DROP SEQUENCE IF EXISTS mo_operation_id_seq CASCADE;" |

162 | "DROP SEQUENCE IF EXISTS mo_organization_id_seq CASCADE;" |

163 | "DROP SEQUENCE IF EXISTS mo_platform_id_seq CASCADE;" |

164 | "DROP SEQUENCE IF EXISTS mo_process_id_seq CASCADE;" |

165 | "DROP SEQUENCE IF EXISTS mo_processing_id_seq CASCADE;" |

166 | "DROP SEQUENCE IF EXISTS mo_project_id_seq CASCADE;" |

167 | "DROP SEQUENCE IF EXISTS mo_responsiblepartyinfo_id_seq CASCADE;" |

168 | "DROP SEQUENCE IF EXISTS mo_result_id_seq CASCADE;" |

169 | "DROP SEQUENCE IF EXISTS multiplicity_id_seq CASCADE;" |

170 | "DROP SEQUENCE IF EXISTS multiplicityrange_id_seq CASCADE;" |

171 | "DROP SEQUENCE IF EXISTS namedvalue_id_seq CASCADE;" |

172 | "DROP SEQUENCE IF EXISTS namespace_id_seq CASCADE;" |

173 | "DROP SEQUENCE IF EXISTS om_observation_id_seq CASCADE;" |

174 | "DROP SEQUENCE IF EXISTS om_process_id_seq CASCADE;" |

175 | "DROP SEQUENCE IF EXISTS record_id_seq CASCADE;" |

176 | "DROP SEQUENCE IF EXISTS recordtype_id_seq CASCADE;" |

177 | "DROP SEQUENCE IF EXISTS rs_identifier_id_seq CASCADE;" |

178 | "DROP SEQUENCE IF EXISTS rs_referencesystem_id_seq CASCADE;" |

179 | "DROP SEQUENCE IF EXISTS scale_id_seq CASCADE;" |

180 | "DROP SEQUENCE IF EXISTS sc_compoundcrs_id_seq CASCADE;" |

181 | "DROP SEQUENCE IF EXISTS sc_crs_id_seq CASCADE;" |

182 | "DROP SEQUENCE IF EXISTS sc_derivedcrs_id_seq CASCADE;" |

183 | "DROP SEQUENCE IF EXISTS sc_generalderivedcrs_id_seq CASCADE;" |

184 | "DROP SEQUENCE IF EXISTS schema_id_seq CASCADE;" |

185 | "DROP SEQUENCE IF EXISTS scopedname_id_seq CASCADE;" |

186 | "DROP SEQUENCE IF EXISTS sc_singlecrs_id_seq CASCADE;" |

187 | "DROP SEQUENCE IF EXISTS sc_verticalcrs_id_seq CASCADE;" |

188 | "DROP SEQUENCE IF EXISTS time_id_seq CASCADE;" |

189 | "DROP SEQUENCE IF EXISTS tm_complex_id_seq CASCADE;" |

190 | "DROP SEQUENCE IF EXISTS tm_duration_id_seq CASCADE;" |

191 | "DROP SEQUENCE IF EXISTS tm_edge_id_seq CASCADE;" |

192 | "DROP SEQUENCE IF EXISTS tm_geometricprimitive_id_seq CASCADE;" |

193 | "DROP SEQUENCE IF EXISTS tm_instant_id_seq CASCADE;" |

194 | "DROP SEQUENCE IF EXISTS tm_node_id_seq CASCADE;" |

195 | "DROP SEQUENCE IF EXISTS tm_object_id_seq CASCADE;" |

196 | "DROP SEQUENCE IF EXISTS tm_periodduration_id_seq CASCADE;" |

197 | "DROP SEQUENCE IF EXISTS tm_period_id_seq CASCADE;" |

198 | "DROP SEQUENCE IF EXISTS tm_position_id_seq CASCADE;" |

199 | "DROP SEQUENCE IF EXISTS tm_primitive_id_seq CASCADE;" |

200 | "DROP SEQUENCE IF EXISTS tm_referencesystem_id_seq CASCADE;" |

201 | "DROP SEQUENCE IF EXISTS tm_temporalposition_id_seq CASCADE;" |

202 | "DROP SEQUENCE IF EXISTS tm_topologicalcomplex_id_seq CASCADE;" |

203 | "DROP SEQUENCE IF EXISTS tm_topologicalprimitive_id_seq CASCADE;" |

204 | "DROP SEQUENCE IF EXISTS tp_complex_id_seq CASCADE;" |

205 | "DROP SEQUENCE IF EXISTS tp_directedtopo_id_seq CASCADE;" |

206 | "DROP SEQUENCE IF EXISTS tp_expression_id_seq CASCADE;" |

207 | "DROP SEQUENCE IF EXISTS tp_expressionterm_id_seq CASCADE;" |

208 | "DROP SEQUENCE IF EXISTS tp_primitive_id_seq CASCADE;" |

209 | "DROP SEQUENCE IF EXISTS type_id_seq CASCADE;" |

210 | "DROP SEQUENCE IF EXISTS typename_id_seq CASCADE;" |

211 | "DROP SEQUENCE IF EXISTS unitofmeasure_id_seq CASCADE;" |

212 | "DROP SEQUENCE IF EXISTS unlimitedinteger_id_seq CASCADE;" |

213 | "DROP SEQUENCE IF EXISTS uomlength_id_seq CASCADE;" |

214 | "DROP SEQUENCE IF EXISTS uomscale_id_seq CASCADE;" |

215 | "DROP SEQUENCE IF EXISTS url_id_seq CASCADE;" |

216 | |

217 | |

218 | "DROP TABLE IF EXISTS any CASCADE;" |

219 | "DROP TABLE IF EXISTS cc_concatenatedoperation CASCADE;" |

220 | "DROP TABLE IF EXISTS cc_conversion CASCADE;" |

221 | "DROP TABLE IF EXISTS cc_coordinateoperation CASCADE;" |

222 | "DROP TABLE IF EXISTS cc_formula CASCADE;" |

223 | "DROP TABLE IF EXISTS cc_generaloperationparameter CASCADE;" |

224 | "DROP TABLE IF EXISTS cc_generalparametervalue CASCADE;" |

225 | "DROP TABLE IF EXISTS cc_operationmethod CASCADE;" |

226 | "DROP TABLE IF EXISTS cc_operationparametergroup CASCADE;" |

227 | "DROP TABLE IF EXISTS cc_parametervaluegroup CASCADE;" |

228 | "DROP TABLE IF EXISTS cc_passthroughoperation CASCADE;" |

229 | "DROP TABLE IF EXISTS cc_singleoperation CASCADE;" |

230 | "DROP TABLE IF EXISTS cd_datum CASCADE;" |

231 | "DROP TABLE IF EXISTS cd_verticaldatum CASCADE;" |

232 | "DROP TABLE IF EXISTS ceda_acquisition CASCADE;" |

233 | "DROP TABLE IF EXISTS ceda_citation CASCADE;" |

234 | "DROP TABLE IF EXISTS ceda_compositeprocess CASCADE;" |

235 | "DROP TABLE IF EXISTS ceda_instrument CASCADE;" |

236 | "DROP TABLE IF EXISTS ceda_notes CASCADE;" |

237 | "DROP TABLE IF EXISTS ceda_observation CASCADE;" |

238 | "DROP TABLE IF EXISTS ceda_observationcollection CASCADE;" |

239 | "DROP TABLE IF EXISTS ceda_operation CASCADE;" |

240 | "DROP TABLE IF EXISTS ceda_platform CASCADE;" |

241 | "DROP TABLE IF EXISTS ceda_process CASCADE;" |

242 | "DROP TABLE IF EXISTS ceda_processing CASCADE;" |

243 | "DROP TABLE IF EXISTS ceda_project CASCADE;" |

244 | "DROP TABLE IF EXISTS ceda_result CASCADE;" |

245 | "DROP TABLE IF EXISTS ceda_review CASCADE;" |

246 | "DROP TABLE IF EXISTS ci_address CASCADE;" |

247 | "DROP TABLE IF EXISTS ci_citation CASCADE;" |

248 | "DROP TABLE IF EXISTS ci_contact CASCADE;" |

249 | "DROP TABLE IF EXISTS ci_date CASCADE;" |

250 | "DROP TABLE IF EXISTS ci_individual CASCADE;" |

251 | "DROP TABLE IF EXISTS ci_onlineresource CASCADE;" |

252 | "DROP TABLE IF EXISTS ci_organisation CASCADE;" |

253 | "DROP TABLE IF EXISTS ci_party CASCADE;" |

254 | "DROP TABLE IF EXISTS ci_responsibility CASCADE;" |

255 | "DROP TABLE IF EXISTS ci_responsibleparty CASCADE;" |

256 | "DROP TABLE IF EXISTS ci_responsiblepartyinfo CASCADE;" |

257 | "DROP TABLE IF EXISTS ci_series CASCADE;" |

258 | "DROP TABLE IF EXISTS ci_telephone CASCADE;" |

259 | "DROP TABLE IF EXISTS class13_0 CASCADE;" |

260 | "DROP TABLE IF EXISTS class13_1 CASCADE;" |

261 | "DROP TABLE IF EXISTS class13_2 CASCADE;" |

262 | "DROP TABLE IF EXISTS class13_3 CASCADE;" |

263 | "DROP TABLE IF EXISTS cl_dataset CASCADE;" |

264 | "DROP TABLE IF EXISTS clocktime CASCADE;" |

265 | "DROP TABLE IF EXISTS cs_coordinatesystemaxis CASCADE;" |

266 | "DROP TABLE IF EXISTS cs_coordinatesystem CASCADE;" |

267 | "DROP TABLE IF EXISTS cs_verticalcs CASCADE;" |

268 | "DROP TABLE IF EXISTS cv_attributevalues CASCADE;" |

269 | "DROP TABLE IF EXISTS cv_coverage CASCADE;" |

270 | "DROP TABLE IF EXISTS cv_domainobject CASCADE;" |

271 | "DROP TABLE IF EXISTS cv_footprint CASCADE;" |

272 | "DROP TABLE IF EXISTS cv_grid CASCADE;" |

273 | "DROP TABLE IF EXISTS cv_gridcell CASCADE;" |

274 | "DROP TABLE IF EXISTS cv_gridcoordinate CASCADE;" |

275 | "DROP TABLE IF EXISTS cv_gridenvelope CASCADE;" |

276 | "DROP TABLE IF EXISTS cv_gridpoint CASCADE;" |

277 | "DROP TABLE IF EXISTS cv_referenceablegrid CASCADE;" |

278 | "DROP TABLE IF EXISTS date CASCADE;" |

279 | "DROP TABLE IF EXISTS dateprecision CASCADE;" |

280 | "DROP TABLE IF EXISTS datetime CASCADE;" |

281 | "DROP TABLE IF EXISTS directposition CASCADE;" |

282 | "DROP TABLE IF EXISTS distance CASCADE;" |

283 | "DROP TABLE IF EXISTS dq_dataquality CASCADE;" |

284 | "DROP TABLE IF EXISTS dq_element CASCADE;" |

285 | "DROP TABLE IF EXISTS dq_positionalaccuracy CASCADE;" |

286 | "DROP TABLE IF EXISTS dq_result CASCADE;" |

287 | "DROP TABLE IF EXISTS dq_scope CASCADE;" |

288 | "DROP TABLE IF EXISTS ds_aggregate CASCADE;" |

289 | "DROP TABLE IF EXISTS ds_aggregate_ds_aggregate CASCADE;" |

290 | "DROP TABLE IF EXISTS ds_dataset CASCADE;" |

291 | "DROP TABLE IF EXISTS earootclass CASCADE;" |

292 | "DROP TABLE IF EXISTS ex_extent CASCADE;" |

293 | "DROP TABLE IF EXISTS ex_geographicdescription CASCADE;" |

294 | "DROP TABLE IF EXISTS ex_geographicextent CASCADE;" |

295 | "DROP TABLE IF EXISTS ex_temporalextent CASCADE;" |

296 | "DROP TABLE IF EXISTS ex_verticalextent CASCADE;" |

297 | "DROP TABLE IF EXISTS genericname CASCADE;" |

298 | "DROP TABLE IF EXISTS gf_associationrole CASCADE;" |

299 | "DROP TABLE IF EXISTS gf_associationtype CASCADE;" |

300 | "DROP TABLE IF EXISTS gf_attributetype CASCADE;" |

301 | "DROP TABLE IF EXISTS gf_attributetype_gf_attributetype CASCADE;" |

302 | "DROP TABLE IF EXISTS gf_constraint CASCADE;" |

303 | "DROP TABLE IF EXISTS gf_featuretype CASCADE;" |

304 | "DROP TABLE IF EXISTS gfi_feature CASCADE;" |

305 | "DROP TABLE IF EXISTS gf_inheritancerelation CASCADE;" |

306 | "DROP TABLE IF EXISTS gf_operation CASCADE;" |

307 | "DROP TABLE IF EXISTS gf_propertytype CASCADE;" |

308 | "DROP TABLE IF EXISTS gm_complex CASCADE;" |

309 | "DROP TABLE IF EXISTS gm_complex_gm_complex CASCADE;" |

310 | "DROP TABLE IF EXISTS gm_composite CASCADE;" |

311 | "DROP TABLE IF EXISTS gm_compositepoint CASCADE;" |

312 | "DROP TABLE IF EXISTS gm_object CASCADE;" |

313 | "DROP TABLE IF EXISTS gm_orientableprimitive CASCADE;" |

314 | "DROP TABLE IF EXISTS gm_point CASCADE;" |

315 | "DROP TABLE IF EXISTS gm_primitive CASCADE;" |

316 | "DROP TABLE IF EXISTS gm_primitive_gm_primitive CASCADE;" |

317 | "DROP TABLE IF EXISTS io_identifiedobjectbase CASCADE;" |

318 | "DROP TABLE IF EXISTS io_identifiedobject CASCADE;" |

319 | "DROP TABLE IF EXISTS le_algorithm CASCADE;" |

320 | "DROP TABLE IF EXISTS length CASCADE;" |

321 | "DROP TABLE IF EXISTS le_nominalresolution CASCADE;" |

322 | "DROP TABLE IF EXISTS le_source CASCADE;" |

323 | "DROP TABLE IF EXISTS li_lineage CASCADE;" |

324 | "DROP TABLE IF EXISTS li_processstep CASCADE;" |

325 | "DROP TABLE IF EXISTS li_source CASCADE;" |

326 | "DROP TABLE IF EXISTS localname CASCADE;" |

327 | "DROP TABLE IF EXISTS md_aggregateinformation CASCADE;" |

328 | "DROP TABLE IF EXISTS md_applicationschemainformation CASCADE;" |

329 | "DROP TABLE IF EXISTS md_browsegraphic CASCADE;" |

330 | "DROP TABLE IF EXISTS md_constraints CASCADE;" |

331 | "DROP TABLE IF EXISTS md_contentinformation CASCADE;" |

332 | "DROP TABLE IF EXISTS md_digitaltransferoptions CASCADE;" |

333 | "DROP TABLE IF EXISTS md_distribution CASCADE;" |

334 | "DROP TABLE IF EXISTS md_distributor CASCADE;" |

335 | "DROP TABLE IF EXISTS md_extendedelementinformation CASCADE;" |

336 | "DROP TABLE IF EXISTS md_format CASCADE;" |

337 | "DROP TABLE IF EXISTS md_identification CASCADE;" |

338 | "DROP TABLE IF EXISTS md_identifier CASCADE;" |

339 | "DROP TABLE IF EXISTS md_keywords CASCADE;" |

340 | "DROP TABLE IF EXISTS md_maintenanceinformation CASCADE;" |

341 | "DROP TABLE IF EXISTS md_medium CASCADE;" |

342 | "DROP TABLE IF EXISTS md_metadata CASCADE;" |

343 | "DROP TABLE IF EXISTS md_metadataextensioninformation CASCADE;" |

344 | "DROP TABLE IF EXISTS md_portrayalcataloguereference CASCADE;" |

345 | "DROP TABLE IF EXISTS md_referencesystem CASCADE;" |

346 | "DROP TABLE IF EXISTS md_representativefraction CASCADE;" |

347 | "DROP TABLE IF EXISTS md_scopedescription CASCADE;" |

348 | "DROP TABLE IF EXISTS md_spatialrepresentation CASCADE;" |

349 | "DROP TABLE IF EXISTS md_standardorderprocess CASCADE;" |

350 | "DROP TABLE IF EXISTS md_usage CASCADE;" |

351 | "DROP TABLE IF EXISTS measure CASCADE;" |

352 | "DROP TABLE IF EXISTS mo_acquisition CASCADE;" |

353 | "DROP TABLE IF EXISTS mo_compositeprocess CASCADE;" |

354 | "DROP TABLE IF EXISTS mo_computation CASCADE;" |

355 | "DROP TABLE IF EXISTS mo_inputoutput CASCADE;" |

356 | "DROP TABLE IF EXISTS mo_instrument CASCADE;" |

357 | "DROP TABLE IF EXISTS mo_instrument_mo_instrument CASCADE;" |

358 | "DROP TABLE IF EXISTS mo_instrumentplatformpair CASCADE;" |

359 | "DROP TABLE IF EXISTS mo_location CASCADE;" |

360 | "DROP TABLE IF EXISTS mo_observation CASCADE;" |

361 | "DROP TABLE IF EXISTS mo_observationcollection CASCADE;" |

362 | "DROP TABLE IF EXISTS mo_observationcollection_mo_observationcollection CASCADE;" |

363 | "DROP TABLE IF EXISTS mo_onlineresource CASCADE;" |

364 | "DROP TABLE IF EXISTS mo_operation CASCADE;" |

365 | "DROP TABLE IF EXISTS mo_operation_mo_operation CASCADE;" |

366 | "DROP TABLE IF EXISTS mo_organization CASCADE;" |

367 | "DROP TABLE IF EXISTS mo_platform CASCADE;" |

368 | "DROP TABLE IF EXISTS mo_platform_mo_platform CASCADE;" |

369 | "DROP TABLE IF EXISTS mo_process CASCADE;" |

370 | "DROP TABLE IF EXISTS mo_processing CASCADE;" |

371 | "DROP TABLE IF EXISTS mo_project CASCADE;" |

372 | "DROP TABLE IF EXISTS mo_project_mo_project CASCADE;" |

373 | "DROP TABLE IF EXISTS mo_responsiblepartyinfo CASCADE;" |

374 | "DROP TABLE IF EXISTS mo_result CASCADE;" |

375 | "DROP TABLE IF EXISTS mo_result_mo_result CASCADE;" |

376 | "DROP TABLE IF EXISTS multiplicity CASCADE;" |

377 | "DROP TABLE IF EXISTS multiplicityrange CASCADE;" |

378 | "DROP TABLE IF EXISTS namedvalue CASCADE;" |

379 | "DROP TABLE IF EXISTS namespace CASCADE;" |

380 | "DROP TABLE IF EXISTS obs_coll_migration CASCADE;" |

381 | "DROP TABLE IF EXISTS observation_migration CASCADE;" |

382 | "DROP TABLE IF EXISTS om_observation CASCADE;" |

383 | "DROP TABLE IF EXISTS om_observation_om_observation CASCADE;" |

384 | "DROP TABLE IF EXISTS om_process CASCADE;" |

385 | "DROP TABLE IF EXISTS record CASCADE;" |

386 | "DROP TABLE IF EXISTS recordtype CASCADE;" |

387 | "DROP TABLE IF EXISTS rs_identifier CASCADE;" |

388 | "DROP TABLE IF EXISTS rs_referencesystem CASCADE;" |

389 | "DROP TABLE IF EXISTS scale CASCADE;" |

390 | "DROP TABLE IF EXISTS sc_compoundcrs CASCADE;" |

391 | "DROP TABLE IF EXISTS sc_crs CASCADE;" |

392 | "DROP TABLE IF EXISTS sc_derivedcrs CASCADE;" |

393 | "DROP TABLE IF EXISTS sc_generalderivedcrs CASCADE;" |

394 | "DROP TABLE IF EXISTS schema CASCADE;" |

395 | "DROP TABLE IF EXISTS scopedname CASCADE;" |

396 | "DROP TABLE IF EXISTS sc_singlecrs CASCADE;" |

397 | "DROP TABLE IF EXISTS sc_verticalcrs CASCADE;" |

398 | "DROP TABLE IF EXISTS time CASCADE;" |

399 | "DROP TABLE IF EXISTS tm_complex CASCADE;" |

400 | "DROP TABLE IF EXISTS tm_duration CASCADE;" |

401 | "DROP TABLE IF EXISTS tm_edge CASCADE;" |

402 | "DROP TABLE IF EXISTS tm_geometricprimitive CASCADE;" |

403 | "DROP TABLE IF EXISTS tm_instant CASCADE;" |

404 | "DROP TABLE IF EXISTS tm_node CASCADE;" |

405 | "DROP TABLE IF EXISTS tm_object CASCADE;" |

406 | "DROP TABLE IF EXISTS tm_period CASCADE;" |

407 | "DROP TABLE IF EXISTS tm_periodduration CASCADE;" |

408 | "DROP TABLE IF EXISTS tm_position CASCADE;" |

409 | "DROP TABLE IF EXISTS tm_primitive CASCADE;" |

410 | "DROP TABLE IF EXISTS tm_referencesystem CASCADE;" |

411 | "DROP TABLE IF EXISTS tm_temporalposition CASCADE;" |

412 | "DROP TABLE IF EXISTS tm_topologicalcomplex CASCADE;" |

413 | "DROP TABLE IF EXISTS tm_topologicalprimitive CASCADE;" |

414 | "DROP TABLE IF EXISTS tp_complex CASCADE;" |

415 | "DROP TABLE IF EXISTS tp_complex_tp_complex CASCADE;" |

416 | "DROP TABLE IF EXISTS tp_directedtopo CASCADE;" |

417 | "DROP TABLE IF EXISTS tp_expression CASCADE;" |

418 | "DROP TABLE IF EXISTS tp_expressionterm CASCADE;" |

419 | "DROP TABLE IF EXISTS tp_primitive CASCADE;" |

420 | "DROP TABLE IF EXISTS tp_primitive_tp_primitive CASCADE;" |

421 | "DROP TABLE IF EXISTS type CASCADE;" |

422 | "DROP TABLE IF EXISTS typename CASCADE;" |

423 | "DROP TABLE IF EXISTS unitofmeasure CASCADE;" |

424 | "DROP TABLE IF EXISTS unlimitedinteger CASCADE;" |

425 | "DROP TABLE IF EXISTS uomlength CASCADE;" |

426 | "DROP TABLE IF EXISTS uomscale CASCADE;" |

427 | "DROP TABLE IF EXISTS url CASCADE;" |

428 | |

429 |

**Note:**See TracBrowser for help on using the repository browser.