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

Error in Smart Rename when changing table schema

tkdennistkdennis Posts: 114
edited July 2, 2014 5:47PM in SQL Prompt
I am still getting a precedence error (on a view) when I change the schema of the underlying table. Moving the ALTER SCHEMA/TRANSFER statement to before the view eliminates the error.

SQL Prompt version


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post!

    I have logged a support ticket for you and emailed you for more details.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    CGLuttrellCGLuttrell Posts: 39 Bronze 1
    Hi, I just ran into this same issue yesterday. It tried to recreate triggers on the table in the new schema before the ALTER SCHEMA statement. Moving it up also fixed my issue, but this seems like a bug.
Sign In or Register to comment.