|
10. CREATE PROCEDURE
- CREATE PROCEDURE 紐낅졊臾몄�� �뒪�넗�뼱�뱶 �봽濡쒖떆���瑜� �옉�꽦�븳�떎.
11. CREATE SYNONYM
- CREATE SYNONYM 紐낅졊臾몄�� �떆�끂�떂�쓣 �옉�꽦�븷 �닔 �엳�떎. �떆�끂�떂��� 蹂꾨챸�쓣 �쓽誘명븳�떎. synonym_name�뿉 �쓽�빐 �떆�끂�떂 �씠由꾩쓣 吏��젙�븷 �닔 �엳怨� object_name�뿉�꽌 二쇱뼱吏��뒗 �뜲�씠�꽣踰좎씠�뒪 �삤釉뚯젥�듃(�뀒�씠釉붿씠�굹 酉� �벑)�쓽 �떆�끂�떂�쓣 �옉�꽦�븳�떎.
12. CREATE USER
- CREATE USER 紐낅졊臾몄�� �뜲�씠�꽣踰좎씠�뒪�뿉 �궗�슜�옄瑜� 吏��젙�븯�뒗 紐낅졊臾몄씠�떎. CREATE USER 紐낅졊臾몄쓽 username�뿉 �궗�슜�옄 �씠由꾩쓣, IDENTIFIED BY�뮘�쓽 password�뿉 �뙣�뒪�썙�뱶瑜� 吏��젙�븳�떎.
13. DROP TABLE
- DROP TABLE 紐낅졊臾몄�� �뀒�씠釉붿쓣 �궘�젣�븷 �븣�뿉 �씠�슜�븳�떎. table_name�뿉�꽌 吏��젙�븳 �뀒�씠釉붿쓣 �궘�젣�븳�떎. �씠 �븣 �뀒�씠釉붿뿉 �옉�꽦�릺�뼱 �엳�뒗 �씤�뜳�뒪 �벑�룄 �궘�젣�맂�떎.
�삉 DROP TABLE 紐낅졊臾몄쑝濡� �뀒�씠釉붿쓣 �궘�젣�븯硫� ROLL BACK�쓣 �궗�슜�빐�룄 �씠�쟾�쑝濡� �룎由� �닔 �뾾�떎.
14. DROP INDEX
- DROP INDEX 紐낅졊臾몄�� �씤�뜳�뒪瑜� �궘�젣�븯�뒗 紐낅졊臾몄씠�떎. index_name�뿉 吏��젙�맂 �씤�뜳�뒪瑜� �궘�젣�븳�떎.
15. DROP VIEW
- DROP VIEW 紐낅졊臾몄�� 酉곕�� �궘�젣�븯�뒗 紐낅졊�씠�떎. VIEW_NAME �씤�닔�뿉 吏��젙�븳 酉곕�� �궘�젣�븳�떎. 酉곕�� �궘�젣�븷 �븣�쓽 二쇱쓽�븷 �젏��� �궘�젣�븳 酉곕�� 洹쇨굅濡� �븯怨� �엳�뒗 酉곕룄 �궗�슜�븷 �닔 �뾾寃� �맂�떎�뒗 �젏�씠�떎.
|
인 쇄
바로가기
�뜲�씠�꽣 �젙�쓽 �뼵�뼱.hwp
[Size :
15 Kbyte
]
장바구니
