Guys thanks for all your response. Answer to the question by Dan is ...

Here is a data sample:

1. customer "WALMART CORPORATE" with id = 1 AND parent_id =...

Thank you for both of you. You have save me a lot of pain and man hours. It is so nice to have a very active and vibrate...

I've tried running it, to most part it works, but it gives an error because it cannot drop a unique constraint. For example I have a table that a...

Thank you for your prompt help. Just a side note, on the where clause why do you include the clause "i.name not like '_WA_Sys_%'?

Peter,

Tried your sql and it works!

Thanks you very much for you help and time.

God Bless you.

John,

1. Dropping all the primary keys will be at least a one time task in order for us to fix an old problem. We found out that some...

Both your solutions works great and I like to thank you very much for responding soon and helping me.