In a refactoring project, we determined we needed to put our maintenance and logging tables in a serperate database from the customer data.
I created this statement to create views pointing to the new table locations to maintain backward compatibility for existing objects.
I recommend you run this on the new database location as it will include the reference to the new database in the defintion. Otherwise, you'll want to update the code to hardcode your new database name.
Hope this saves you some time creating views!