表 :if exists (select * from sysobjects where name='name' and xtype='U')
begin
……
end
库 :if exists (select * from sysdatabases where name='name' )
begin
……
end
begin
……
end
库 :if exists (select * from sysdatabases where name='name' )
begin
……
end
库最好用
if exists (select * from master..sysdatabases where name='name' )
begin
……
end
create table ...库 :if not exists (select * from sysdatabases where name='name' )
create database ...