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.
TRUNCATE TABLE dn.table1to
TRUNCATE TABLE dbo.table1
0 · Share on Twitter