Qualify Object names - changed schema

tkdennistkdennis 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.
TRUNCATE TABLE dn.table1
to
TRUNCATE TABLE dbo.table1

Thanks,
Traci

Comments

Sign In or Register to comment.