3 replies

When using a foreignKey({}), is there a way to specify onDelete: "cascade'?

I'm looking to custom name my foreign keys so I need to use the foreignKey() function. However, how can I specify an action: {onDelete: "cacade"} using this function?

  userIdReference: foreignKey(
    {
      columns: [table.userId],
      foreignColumns: [users.userId],
      name: "accounts_user_id_fk",
    },
  ),

  userIdReference: foreignKey(
    {
      columns: [table.userId],
      foreignColumns: [users.userId],
      name: "accounts_user_id_fk",
    },
  ),

To my understanding, if I use the

.references()

.references()

method, it doesn't allow for naming foreign keys

userId: integer('user_id').references(() => users.id, { onDelete: 'cascade' })

userId: integer('user_id').references(() => users.id, { onDelete: 'cascade' })

Drizzle Team•2y ago•

3 replies

Paul

When using a foreignKey({}), is there a way to specify onDelete: "cascade'?

I'm looking to custom name my foreign keys so I need to use the foreignKey() function. However, how can I specify an action: {onDelete: "cacade"} using this function?

  userIdReference: foreignKey(
    {
      columns: [table.userId],
      foreignColumns: [users.userId],
      name: "accounts_user_id_fk",
    },
  ),

  userIdReference: foreignKey(
    {
      columns: [table.userId],
      foreignColumns: [users.userId],
      name: "accounts_user_id_fk",
    },
  ),

To my understanding, if I use the

.references()

.references()

method, it doesn't allow for naming foreign keys

userId: integer('user_id').references(() => users.id, { onDelete: 'cascade' })

userId: integer('user_id').references(() => users.id, { onDelete: 'cascade' })

When using a foreignKey({}), is there a way to specify onDelete: "cascade'?

Similar Threads

When using a foreignKey({}), is there a way to specify onDelete: "cascade'?

Similar Threads

Similar Threads

Similar Threads