Skip to content
Search

SQL:Alter

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

Add a column

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;

Drop a column

ALTER TABLE recc_port DROP COLUMN description;

Postgresql Examples

See PostgreSQL:AlterTable.

See also

author Zer0 sitemap