thanks to username slimdave...it is a plain select with the output used to truncate every table individualy.

thanks to username sai_sathish...will try your reply!!