如果是SQL SERVER,要判断表problem是否存在,如果存在则删除,用下面的语句: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[problem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[problem]
Access: 列出所有的表.要查某个表加一个条件就是 SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name; 详见: http://dev.csdn.net/article/42/article/46/article/43/43168.shtm
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[problem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[problem]
列出所有的表.要查某个表加一个条件就是
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;
详见:
http://dev.csdn.net/article/42/article/46/article/43/43168.shtm
用ADO的话,ADO连接的GetTableNames可以得到所有表名,你去找看里面有没有你想知道的表就行了
try
新建此表
except
showmessage('表已存在!')
end
不就得了?当然,前提是你的数据连结是正常的。