【PostgreSQL】postgersでカラム追加

1 |
<span class="k">ALTER</span> <span class="k">TABLE</span> <span class="n">domains</span> <span class="k">ADD</span> <span class="k">COLUMN</span> <span class="k">domain</span> <span class="nb">VARCHAR</span><span class="p">(</span><span class="mi">50</span><span class="p">);</span> |
1 |
ALTER TABLE テーブル名 ADD COLUMN 追加カラム名 型; |
1 |
<span class="k">ALTER</span> <span class="k">TABLE</span> <span class="n">domains</span> <span class="k">DROP</span> <span class="k">COLUMN</span> <span class="k">domain</span><span class="p">;</span> |