I was so happy today when I checked a site that gets a lot of user submitted content and realized that I had been able to grab my database from my US hosting company, send it overseas, and get it restored without any new UGC to copy over. Then I realized that all of my queries were broken and after some trouble shooting I realized that all of my tables that were not part of the (dbo) schema were renamed in server explorer to include the name (defautschema) which would require the renaming of my queries to specify defaultschema.tablename on all non (dbo) schema tables.
The first thing I tried to do was right click on the names of the tables and select rename to delete them right there in Server Exporer, but no such option exists. Then I followed the directions for renaming tables, but the table names in the table definition do not include the schema names. I also tried deleting the schema, but got an error message saying that I have to have a schema.
Is there any way for me to change the names of the tables so that I don't have to add "schemaname." to every single column name in ever query that I have ever written?
View Complete Post