go use TEST_Db go if exists(select * from sysobjects where name='T1') drop table T1 go create table T1 ( Id int identity(1,1) primary key, userName varchar(20) not null, ) go