| Author |
Message |
tkdennis
Joined: 29 Feb 2008
Posts: 74
|
 Posted: Tue Jun 08, 2010 4:35 am Post subject: Qualify Object names - changed schema |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Wed Jun 09, 2010 1:56 pm Post subject: |
|
|
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 |
|
|
|
|
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
