Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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 6.3.0.345

Comments

  • 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: [email protected]
  • CGLuttrellCGLuttrell Knoxville, TNPosts: 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.
    Thanks,
    Chris
Sign In or Register to comment.