How to clear OpenStack Nova instance table

delete from instance_faults;
delete from instance_extra;
delete from instance_info_caches;
delete from instance_system_metadata;
delete from block_device_mapping;
delete from instances;