SQL Server: Unable to rename a column referenced by a relation

[pimeys]

Bug description

Renaming e.g. an id column that is referenced in a relation, will lead to a database error:

Error querying the database: 'There is already an object named 'FK__Post__authorId' in the database.' on server 6fb6df574dfa executing  on line 1 (code: 2714, state: 5, class: 16)

How to reproduce

Starting with the following data model, pushing it to the database:

model Post {
  id        Int     @default(autoincrement()) @id
  author    User?   @relation(fields: [authorId], references: [id])
  authorId  Int?
}

model User {
  id      Int     @default(autoincrement()) @id
  posts   Post[]
}

Next, we rename the id field of the User model to uId, changing the references: [id] to references: [uId] in the Post's author relation:

model Post {
  id        Int     @default(autoincrement()) @id
  author    User?   @relation(fields: [authorId], references: [uId])
  authorId  Int?
}

model User {
  uId      Int     @default(autoincrement()) @id
  posts    Post[]
}

Pushing this schema will lead to the error mentioned above.

Expected behavior

It should drop the key first, then create a new one.

Environment & setup

• OS: The Best OS (Linux ftw)

Prisma Version

latest master on 2.8.2021.