Database

[sql쿼리] create, select, alter, insert

junjunwon 2020. 8. 13. 17:30

select * from sample_info

 

create table sampleOtp_info (

otp_id int not null,

otp_user varchar(10) not null

)

--테이블 삭제

drop table [테이블 명]

 

select * from sampleOtp_info

 

alter table sample_info add req_desc varchar(50)

 

 

insert into sample_info  values (4, '안녕하세요. Test 입니다.','컴퓨터 고장으로 인한 신청', '변경사유 없음');

 

 

alter table sample_info add update_desc varchar(50)

 

select * from sample_info

 

- 컬럼 삭제

alter table [vos].[dbo].[temp_junho] drop column modifieddate