请问各位，如何判断一个表已经存在，或是不存在（Delphi + SQL Server)？？？？？？？？？？？？？？？

[loader]

如果表存在就在表中查询，如果不存在，则报告不存在的信息？？？

谢谢

[liang_z]

if not exists (select * from sysobjects where id = object_id('dbo.Table1') and sysstat & 0xf = 3)
select 'Table1 not exists' as Message

[ollea]

建立用户自己的数据字典。进行查询前先从用户的数据字典中查找

[shawy0282]

IF EXISTS (SELECT *
FROM sysdatabases
WHERE name = 'tablename') ......

[loader]

可是如何放到adoquery里面

怎么用？？

[blazingfire]

ADOQuery1.Close;
ADOQuery1.SQL.Text:=' SELECT * FROM sysdatabases'+
' WHERE name = ''tablename''';
ADOQuery1.Open;
if ADOQuery1.Eof and ADOQuery1.Bof then
//产存在这个表

[blazingfire]

ADOQuery1.Close;
ADOQuery1.SQL.Text:=' SELECT * FROM sysdatabases'+
' WHERE name = ''tablename''';
ADOQuery1.Open;
if ADOQuery1.Eof and ADOQuery1.Bof then
//不存在这个表

[mmzxg]

if not exists (select * from sysobjects where id = object_id('dbo.Table') and sysstat & 0xf = 3)
select 'Table not exists' as Message