here is a quick sql script todo this for you
delete from comments
go
delete from sample_info
go
delete from meta_key
go
delete from metainformation
go
delete from runtime
go
delete from bin_compare
go
delete from virtual_bin
go
delete from bin a where a.bin_id not in (select bin_id from standard)
go
delete from samples a where a.sample_id not in (select sample_id from bin)
go
delete from reference_class
go
delete from reference
go
delete from result_link
go
delete from bin_ratio
go
delete from bin_references
go
delete from classification
go
delete from configuration where configuration_id not in (select configuration_id from samples)
go
delete from spectra where sample_id not in (select sample_id from samples)
go
delete from qualitycontrol
go
delete from result
go
delete from standard_hist
go
delete from structure
go
delete from substance_classes
go
delete from synonyme
go
delete from user_validation
go
delete from substance_classes
go
No comments:
Post a Comment