■SQL(StructionQueryLanguage) ✔질의어(QueryLanguage) -DBMS에서DB로부터데이터를뽑아내어보여주는툴,함수 ✔DDL(정의어):DB생성,삭제 -Create:생성(정의),Table,Schema,Vier,Domain등을생성 -Alter:수정,(Add,Drop,Alter)옵션사용 -Drop:삭제,Cascade(참조된모든테이블삭제),Restrict(연결테이블이있으면취소) ✔DCL(제어어):권한,보안 -Commit:연산완료 -Rollback:연산취소 -Grant:권한수여 ➤Grant권한ontable_nametouser_name(withgrantoption); ➤권한:All,Insert,Delete,Update,Select ➤(withgrantoption):사용자가받은권한을다른사용자에..
