Use type serial to make a column type int that autoincrements in SQL Server.
The default type for id is bigserial and creates a PK type of bigint.
defmodule MyApp.Repo.Migrations.CreatePosts do
use Ecto.Migration
def change do
create table("Post", primary_key: [name: :ID, type: :serial]) do
add :Name, :string, null: false
add :Description, :string
timestamps()
end
end






















