Red Gate forums :: View topic - Qualify Object names - changed schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Qualify Object names - changed schema

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tkdennis



Joined: 29 Feb 2008
Posts: 74

PostPosted: Tue Jun 08, 2010 4:35 am    Post subject: Qualify Object names - changed schema Reply with quote

I applied the Qualify Object Names to a whole script, and it changed tables that already had schema names to use the dbo schema. It happened when I changed the USE <database> statement at the top of the script in order to get it to qualify the cross-database references. The other database had tables in the dbo schema.

Code:
TRUNCATE TABLE dn.table1

to
Code:
TRUNCATE TABLE dbo.table1


Thanks,
Traci
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 662
Location: Cambridge

PostPosted: Wed Jun 09, 2010 1:56 pm    Post subject: Reply with quote

Many thanks for your post.

What happens when you remove the Use database statement and select the database which has table 'Table1' in 'dn' schema?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group