Skip to content

SQL:Alter

컬럼 추가

ALTER TABLE public.recc_permission ADD "name" varchar(128) NULL;
ALTER TABLE public.recc_permission ADD hidden bool NOT NULL DEFAULT false;
ALTER TABLE public.recc_permission ADD "lock" bool NOT NULL DEFAULT false;

컬럼 제거

ALTER TABLE recc_port DROP COLUMN description;

Postgresql Examples

PostgreSQL:AlterTable 항목 참조.

See also