Skip to content
- SQL 명령어
- DQL(Data Query Language)
- SELECT
- DML(Data Manipulation Language)
- INSERT
- UPDATE
- DELETE
- DDL(Data Definition Language)
- CREATE
- CREATE TABLE newtable AS SELECT * from oldtable; <–테이블 복사 :
- CREATE TABLE newtable AS SELECT * from oldtable WHERE 1=2; <–테이블만 복사 :
- INSERT INTO newtable SELECT * from oldtable; <–테이블에 내용만 복사 :
- ALTER
- ALTER TABLE table1 ADD col1 int;
- ALTER TABLE table1 DROP COLUMN col1;
- ALTER TABLE table1 RENAME TO table2; <– 테이블 이름 변경
- ALTER TABLE table1 RENAME COLUMN col1 TO col2; <– 필드 이름 변경
- ALTER TABLE table1 MODIFY col1 varchar(20); <– 자료형 변경
- <– 해당 컬럼에 입력정보가 있으면 느리거나, 안되는 경우 발생
- ALTER TABLE table1 ADD PRIMARY KEY(col1);
- ALTER TABLE table1 ADD CONSTRAINTS fk_col1 FOREIGN KEY(col1) REFERENCES ref_table(ref_col2);
- ALTER TABLE table1 DROP CONSTRAINTS fk_col1;
- DROP :
- DROP TABLE table1
- RENAME :
- RENAME table1 TO table2
- TRUNCATE :
- TRUNCATE TABLE table1;
- TCL(Transaction Control Language)
- COMMIT
- ROLLBACK
- SAVEPOINT
- DCL(Data Control Language)
- GRANT
- GRANT create session TO user1;
- REVOKE
- REVOKE create session FROM user1;
error: Content is protected !!