@andrei-pmbcn have you any API in mind how it would work consistently with other knex schema building APIs? If this is a feature request, please write it as one and add some proposal how the feature should work.

For consistency...

QueryBuilder API

.dropTable()
.dropTableIfExists()

SchemaBuilder API

.dropForeign()
.dropForeignIfExists()
.dropUnique()
.dropUniqueIfExists()
.dropPrimary()
.dropPrimaryIfExists()

@wubzz I suppose you meant schema builder API and column builder API? Looks good though.

Edit: fixed typo meat -> meant 😆

@elhigu Err awkward.. Yes that is what I meant. :)

Any movement on this?

@alechirsch Noone is actively working on it. PRs are welcome!

I might look into it if I have time, I just ran into needing this feature. Using raw for now.

For anyone looking for the raw command:

await knex.raw(`ALTER TABLE ${tableName} DROP CONSTRAINT IF EXISTS ${constraint};`)

This is for Postgres and MariaDB. Might need altering for other dbms.

For anyone looking for the raw command:

await knex.raw(`ALTER TABLE ${tableName} DROP CONSTRAINT IF EXISTS ${constraint};`)

This works for MariaDB, but not for MySQL. Haven't tested others.

any updates on this? can I contribute somehow if it is not yet implemented?

@cod3cod3 yup, PR is welcome!

Took a crack at this, it seems pretty straightforward? If this looks right I can do the same for dropForeign and dropPrimary and add tests as well.

master...louispotok:knex:drop-unique-if-exists

@kibertoad Does this look like the right direction?