use sz_dataJDB --创建 create table m_guest ( guesetid varchar(50) not null primary key, guestno varchar(50) not null unique, indexid int identity(1,1) not null, guestname varchar(50), age int check(age>18 and age<99) ) --增加 insert into m_guest(guesetid,guestno,guestname,age) values(NEWID(),'0026','wy','19') --删除表中数据 truncate table m_guest --or delete m_guest --增加列 alter table m_guest add mobile varchar(50) --删除列 alter table m_guest drop column mobile --删除表 --drop table m_guest --查询 select * from m_guest