How can we help you today? How can we help you today?

Error in Smart Rename when changing table schema

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
tkdennis
0

Comments

2 comments

Sort by
  • Anu D
    Thanks for your post!

    I have logged a support ticket for you and emailed you for more details.
    Anu D
    0
  • CGLuttrell
    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
    CGLuttrell
    0

Add comment

Please sign in to leave a comment.