摘要： create table test(name varchar(20),password int)//添加自增alter table test add id int identity(1,1)//前一个1是自增开始的数字，后一个1是自增的间隔alter table test drop column idselect * from testinsert into test values('we',23)insert into test values('www',233)truncate table testdelete from test where name=&# 阅读全文