ifexists(select*from sysobjects where[name]='nb2'and type='U') begin print'该表已存在' return end else begin print'该表不存在' createtable nb2(pid int ,[name]char(10),phone int) print'创建表完成' end
if exists(select * from sysobjects where [name]=nb2 and type=U) begin print该表已存在 return endelse begin print该表不存在 create table nb2(pid int ,[name] char(10),phone int) print