Paul thanks for your reply. no of table limited to 4 is just a example. it may be more than that. U r right that this is a lengthy operation. How you solve ur problem that depends on lots factor. May be don't have a right to create different DB. to copy those table into new one. It's depend on Situation, company policy.
As your solution is well excepted. Its a nice one. I am just sharing my solution. 🙂
thanks for your contribution.
Regards,
Shubha