if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[yingshouxinxiku]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[yingshouxinxiku] GO
用DELPHI来写如下了adoquery.close adoquery.sql.clear adoquery.sql.add('select * from dbo.sysobjects where id = object_id(N'[dbo].[yingshouxinxiku]') and OBJECTPROPERTY(id, N'IsUserTable') = 1') adoquery1.openif adoquery1.recordcount<>0 then begin adoquery.close adoquery.sql.clear adoquery.sql.add('drop table [dbo].[yingshouxinxiku]') adoquery.execl
adoquery.sql.clear
adoquery.sql.add('select * from dbo.sysobjects where id = object_id(N'[dbo].[yingshouxinxiku]') and OBJECTPROPERTY(id, N'IsUserTable') = 1')
adoquery1.openif adoquery1.recordcount<>0 then
begin
adoquery.close
adoquery.sql.clear
adoquery.sql.add('drop table [dbo].[yingshouxinxiku]')
adoquery.execl
end;大概的意思了这样的,你去调试看,如果有问题再提好了,就这样了