怎么用SQL语句实现以下功能?

[chengxuejun]

在Access数据库中有一个名为A的数据表如何用SQL语句实现以下功能:

如果存在A数据表就删除它

[hongqi162]

up

[Delphi_Li]

使用ADO就搞定了！！！

Try
Drop Table Your_Table //这是SQL语句
Except
End

[csdnyong]

可以！！

[maoke000]

procedure TForm1.Button1Click(Sender: TObject);
var LS: TStringList;
tb: String;
begin
tb := 'TableName';
LS := TStringList.Create;
ADOConnection1.GetTableNames(LS);
if LS.IndexOf(tb) > = 0 then
//drop table tablename
LS.Free; //千万别忘了写这行哦

end;

[maoke000]

procedure TForm1.Button1Click(Sender: TObject);
var LS: TStringList;
tb: String;
begin
tb := 'TableName';
LS := TStringList.Create;
ADOConnection1.GetTableNames(LS);
if LS.IndexOf(tb) > = 0 then
//drop table tablename
LS.Free; //千万别忘了写这行哦

end;

[guestman]

你用什么连的access?ado还是bde

[票票飞扬]

//ADOConnection
procedure TForm1.Button1Click(Sender: TObject);
var LS: TStringList;
tb: String;
begin
tb := 'TableName';
LS := TStringList.Create;
ADOConnection1.GetTableNames(LS);
if LS.IndexOf(tb) > = 0 then
//drop table tablename

end;

//要不直接删除
用Try捕获异常