๐Ÿ‘จ‍๐Ÿ’ป kimtongting

์ปฌ๋Ÿผ์ถ”๊ฐ€

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;

 

๋ฐ˜์‘ํ˜•
profile

๐Ÿ‘จ‍๐Ÿ’ป kimtongting

@kimtongting ์ž…๋‹ˆ๋‹ค

ํฌ์ŠคํŒ…์ด ์ข‹์•˜๋‹ค๋ฉด "์ข‹์•„์š”โค๏ธ" ๋˜๋Š” "๊ตฌ๋…๐Ÿ‘๐Ÿป" ํ•ด์ฃผ์„ธ์š”!