SQLメモ

# 項目追加
alter table [table name] add column [column name] [definition]
# 例
alter table user add column tel varchar(50) not null default '';

# テーブル定義参照
# mysql
show create table [table name];

# postgresql on psql
\d [table name]
# postgresql from sql（簡易版）
select
  c.table_name,
  c.ordinal_position,
  c.column_name,
  c.data_type,
  c.character_maximum_length,
  c.is_nullable,
  c.column_default
from
  information_schema.columns c
where
  c.table_name = [table name]
order by
  c.ordinal_position;