콘텐츠로 이동
Search

SQL:Alter

lastmod 2024-11-22created 2021-10-129 edits

컬럼 추가 

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

author Zer0 sitemap