【PostgreSQL】postgersでカラム追加
![](https://vamdemicsystem.black/wp-content/uploads/2019/10/13.jpg)
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> |