What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
Sign In or Register to comment.