Guest User

Untitled

a guest
Jan 22nd, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. 1> 컬럼 추가
  2. ALTER TABLE 테이블명 ADD ( 컬럼명 데이터타입 );
  3. ex) alter table tbl_member add (name varchar(1));
  4.  
  5. 2>컬럼타입 수정
  6. ALTER TABLE 테이블명 MODIFY ( 컬럼명 데이터타입 );
  7. ex) alter table tbl_member modify (name varchar(10));
  8.  
  9. 3>컬럼명 변경
  10. ALTER TABLE 테이블명 RENAME COLUMN old컬럼명 TO new컬럼명;
  11. ex) alter table tbl_member rename column name to new_name;
  12.  
  13. 4> 컬럼삭제
  14. ALTER TABLE 테이블명 DROP(컬럼명);
  15. ex) alter table tbl_member drop (new_name);
Add Comment
Please, Sign In to add comment