mathew4509
How to delete/drop table?
This is my migration. And it is one of the tables in my database. I no longer need this table. Can I know what is the command I use to remove this table? or can I know where I can find commands to delete/remove migrations?
defmodule Blogs.Repo.Migrations.CreatePosts do
use Ecto.Migration
def change do
create table(:posts) do
add :title, :string, null: false
add :slug, :string, null: false
add :body, :string, null: false
timestamps()
end
create unique_index(:posts, [:title])
create unique_index(:posts, [:slug])
end
end
Thanks 
Marked As Solved
KiKi
No, you have to create a new migration, I named it DropPosts here but you can use any name you like.
To generate migration type the following command in terminal. More about it here mix ecto.gen.migration — Ecto SQL v3.14.0
mix ecto.gen.migration drop_posts
And then add change function to the migration file
defmodule Blogs.Repo.Migrations.DropPosts do
use Ecto.Migration
def change do
drop table("posts")
end
end
Also Liked
benwilson512
As a minor note, dropping the indexes is unnecessary, they will be removed when the table they are built for is deleted.
KiKi
drop table("posts")
drop index("posts", [:title])
drop index("posts", [:slug])
APB9785
You’ll need to make a new migration file with a different name, and you can use the same format as you posted in the OP. Then run it with mix ecto.migrate
More details at Ecto.Migration
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"