/*设置自动增量*/
USE [login]
GO
DBCC CHECKIDENT('Student',RESEED,1)
/*设置自动增量*/
ALTER TABLE Student AUTO_INCREMENT =1
/*设置自动增量*/
TRUNCATE TABLE Student
/*设置自动增长为no*/
set identity_insert Class on
/* 为表添加一列*/
alter table student add classNo varchar(20)
/*修改数据类型*/
alter table tableName alter column columnName varchar(4000)
/*修改列名/把表名为tableName的column1列名修改为column2*/
EXEC sp_rename 'tableName.column1' , 'column2'
/*删除一列*/
alter table tableName drop column columnName
select * from Ktudent
select * from person
/* 批量删除数据*/
delete from person where id in(5)
delete from person where id >=3 and id <=10
delete from person where id between 5 and 8