Qualify Object names - changed schema
tkdennis
Posts: 114
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.
Thanks,
Traci
TRUNCATE TABLE dn.table1to
TRUNCATE TABLE dbo.table1
Thanks,
Traci
Comments
What happens when you remove the Use database statement and select the database which has table 'Table1' in 'dn' schema?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com