Create procedure dbo.tng_deletedata
AS
begin
truncate table dbo.tng_browser_menu;
truncate table dbo.tng_browser_method;
truncate table dbo.tng_ip_subnet;
truncate table dbo.tng_jii_inclusion;
truncate table dbo.tng_address_type;
truncate table dbo.tng_adminstatus ;
delete from dbo.tng_alarmset_entry;
delete from dbo.tng_alarmset;
truncate table dbo.tng_auth;
truncate table dbo.tng_change_history;
truncate table dbo.tng_city;
truncate table dbo.tng_property_definition;
truncate table dbo.tng_class_ext;
truncate table dbo.tng_class;
truncate table dbo.tng_conflict_object;
truncate table dbo.tng_country;
truncate table dbo.tng_dbpv;
truncate table dbo.tng_dhcp_scope;
truncate table dbo.tng_geomap;
truncate table dbo.tng_icon_2d;
truncate table dbo.tng_icon_3d;
truncate table dbo.tng_interface_type;
truncate table dbo.tng_ip_discovery_history;
truncate table dbo.tng_ip_interface;
truncate table dbo.tng_jasmine_menu_action;
truncate table dbo.tng_jasmine_menu_object;
truncate table dbo.tng_link;
truncate table dbo.tng_mac_address;
truncate table dbo.tng_map_authority;
truncate table dbo.tng_method;
truncate table dbo.tng_ov_enum;
truncate table dbo.tng_ov_field_def;
truncate table dbo.tng_overlapinterface;
truncate table dbo.tng_pollset;
truncate table dbo.tng_popup_menu;
truncate table dbo.tng_prop_status_history;
truncate table dbo.tng_severity_propagation;
truncate table dbo.tng_status;
truncate table dbo.tng_status_history;
truncate table dbo.tng_sysobjid;
truncate table dbo.tng_tnd_geomap;
truncate table dbo.tng_unclassified_tcp;
truncate table dbo.tng_user_menu;
truncate table dbo.tng_vendor;
truncate table dbo.tng_class_addport;
truncate table dbo.tng_ip_discovery_history;
truncate table dbo.tng_netpc_history;
truncate table dbo.tng_change_history;
truncate table dbo.tng_key_prop_status_hist;
truncate table dbo.tng_key_id;
truncate table dbo.tng_key_class_id;
truncate table dbo.tng_key_discovery_ipsubnet_id;
truncate table dbo.tng_key_status_hist;
truncate table dbo.tng_key_change_hist;
truncate table dbo.tng_class_reclass;
truncate table dbo.tng_locale_info;
truncate table dbo.tng_dbserver_connectinfo;
truncate table dbo.tng_class_special;
truncate table dbo.tng_mac_address;
truncate table dbo.tng_dsm_mo_scope;
truncate table dbo.tng_dsm_class_scope;
truncate table dbo.tng_dsm_poll_scope;
truncate table dbo.tng_dsm_comm_scope;
truncate table dbo.tng_dsm_ip_scope;
truncate table dbo.tng_discovery_ipsubnet;
truncate table dbo.tng_class_special;
truncate table dbo.tng_agent_info;
truncate table dbo.tng_discovery_setup;
truncate table dbo.tng_field_storage;
truncate table dbo.tng_ca_claim_discovery_tmp;
truncate table dbo.tng_discovery_ipsubnet_tmp;
truncate table dbo.tng_managedobject;
truncate table dbo.tng_inclusion;
truncate table dbo.tng_discovery_status;
end

GO