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