์ปฌ๋ผ์ถ๊ฐ
ALTER TABLE board ADD create_date date;
์ปฌ๋ผ์ญ์
ALTER TABLE board DROP create_date;
์ปฌ๋ผ default๊ฐ ์ถ๊ฐ
ALTER TABLE board ALTER COLUMN name SET DEFAULT '์ด๋ฆ์์'; --๋ฌธ์
ALTER TABLE board ALTER COLUMN no SET DEFAULT 1; --์ซ์
์ปฌ๋ผ default๊ฐ ์ ๊ฑฐ
ALTER TABLE board ALTER name DROP DEFAULT;
์ปฌ๋ผ NOT NULL ์ถ๊ฐ
ALTER TABLE board ALTER COLUMN name SET NOT NULL;
์ปฌ๋ผ NOT NULL ์ ๊ฑฐ
ALTER TABLE board ALTER COLUMN name DROP NOT NULL;
ํ ์ด๋ธ ์ด๋ฆ ๋ณ๊ฒฝ
ALTER TABLE board RENAME TO TB_board;
์ปฌ๋ผ๋ช ๋ณ๊ฒฝ
ALTER TABLE board RENAME COLUMN id TO user_id;
์ปฌ๋ผ ๋ฐ์ดํฐ ํ์ ๋ณ๊ฒฝ
ALTER TABLE board ALTER COLUMN id TYPE text;
constraint (์ ์ฝ์กฐ๊ฑด) ์ถ๊ฐ
ALTER TABLE board ADD CONSTRAINT board_code FOREIGN KEY (board_id) REFERENCES boards (id);
ALTER TABLE board ADD CONSTRAINT board_rule CHECK (type='A' OR type='B');
constraint (์ ์ฝ์กฐ๊ฑด) ๋ณ๊ฒฝ (๋ณ๊ฒฝ์ ์๊ณ drop -> add)
ALTER TABLE board DROP CONSTRAINT board_type_check;
ALTER TABLE board ADD CONSTRAINT board_type_check CHECK (type=ANY(ARRAY[0::smallint, 1::smallint, 2::smallint]));
ํ ์ด๋ธ ์์ ์ ๋ณ๊ฒฝ
ALTER TABLE employees OWNER TO postgres;
์ํ์ค ์ด๊ธฐํ
ALTER SEQUENCE TB_USER_SEQ RESTART WITH 1;
๋ฐ์ํ