query does not take into account the table schema so it is fails in my database. It will only work if all tables are in the dbo schema, which is not a best practice.
Thank You Jeff. We can add the table schema in the script. I will test it and update the script.