Search

๋ทฐ

๋ทฐ(View)

๋ทฐ๋Š” ํ•˜๋‚˜ ์ด์ƒ์˜ ํ…Œ์ด๋ธ”์ด๋‚˜ ๋‹ค๋ฅธ ๋ทฐ๋ฅผ ๊ธฐ๋ฐ˜์œผ๋กœ ๋งŒ๋“ค์–ด์ง„ ๊ฐ€์ƒ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค.
์‹ค์ œ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜์ง€ ์•Š๊ณ , ์ฟผ๋ฆฌ์˜ ๊ฒฐ๊ณผ๋ฅผ ๋‚˜ํƒ€๋‚ด๋Š” ๋…ผ๋ฆฌ์ ์ธ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค.

๋ทฐ์˜ ํŠน์ง•

โ€ข
๋ฐ์ดํ„ฐ์˜ ๋…๋ฆฝ์„ฑ์„ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค
โ€ข
๋ณต์žกํ•œ ์ฟผ๋ฆฌ๋ฅผ ๋‹จ์ˆœํ™”ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค
โ€ข
๋ณด์•ˆ์„ฑ์„ ํ–ฅ์ƒ์‹œํ‚ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค (ํŠน์ • ์ปฌ๋Ÿผ๋งŒ ๋ณด์—ฌ์ฃผ๊ธฐ ๊ฐ€๋Šฅ)
โ€ข
๋ฐ์ดํ„ฐ ์ง‘๊ณ„์™€ ์žฌ์‚ฌ์šฉ์ด ์šฉ์ดํ•ฉ๋‹ˆ๋‹ค
โ€ข
์„œ๋ธŒ์ฟผ๋ฆฌ๋ฅผ ๋Œ€์ฒดํ•˜์—ฌ ์„ฑ๋Šฅ์„ ํ–ฅ์ƒ์‹œํ‚ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค

์ฝ”๋“œ

1. ๋ทฐ ์ƒ์„ฑ

CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;
SQL
๋ณต์‚ฌ

2. ๋ทฐ ์ˆ˜์ •

ALTER VIEW view_name AS SELECT column1, column2, column3 FROM table_name WHERE condition;
SQL
๋ณต์‚ฌ

3. ๋ทฐ ์‚ญ์ œ

DROP VIEW view_name;
SQL
๋ณต์‚ฌ
์ฃผ์˜์‚ฌํ•ญ: ๋ทฐ๋ฅผ ์ƒ์„ฑํ•  ๋•Œ๋Š” ๊ธฐ๋ณธ ํ…Œ์ด๋ธ”์˜ ๋ฌด๊ฒฐ์„ฑ๊ณผ ์ œ์•ฝ์กฐ๊ฑด์„ ๊ณ ๋ คํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.