Kindly have a look at the settings in option set, for that navigate to
SQL prompt 4 --> Options --> Inserted Code --> Qualification --> Uncheck Qualify Object name with owner name and Qualify Column name with table name and it should work as per your requirement.
Kindly let us know if that helped.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Comments
Kindly have a look at the settings in option set, for that navigate to
SQL prompt 4 --> Options --> Inserted Code --> Qualification --> Uncheck Qualify Object name with owner name and Qualify Column name with table name and it should work as per your requirement.
Kindly let us know if that helped.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com