adoquery可以这样删除表么？？？？？？？？？？？？？？？？

Question

with Ndm.adoquery do
                                begin
                                    Close;
                                    Sql.Clear;
                                    Sql.Add('delete table1');
                                    Sql.Add('delete table2');
                                    ExecSql;
                                end;如果这样不行，怎么办/

Answer 1

delete：删除表内数据
Drop TableName：删除表结构如果想删除数据，sql2k的服务器，你的写法是可行的

Answer 2

Drop Table Table1：删除表Table1结构

Answer 3

XXSingle(水连天【五行忌水，所以没有女人】) 
好像不行我试过了 只删除了table1的数据.

Answer 4

with Ndm.adoquery do
                                begin
                                    Close;
                                    Sql.Clear;
                                    Sql.Add(Drop table table1');
                                    Sql.Add(Drop table table2');
                                    ExecSql;
                                end;

Answer 5

with Ndm.adoquery do
  begin
    Close;
    Sql.Clear;
    Sql.Add('delete from table1');
    ExecSql;
    Close;
    Sql.clear;
    Sql.Add('delete from table2');
    ExecSQL;
  end;