var tmpadoquery1:tadoquery; tmpadoquery2:tadoquery; begin tmpadoquery1:=tadoquery.create(); tmpadoquery2:=tadoquery.create(); tmpadoquery1.connection:=odfo;//master数据库; tmpadoquery2.connection:=djfkk;//你要删除表的数据库 tmpadoquery2.Close; tmpadoquery2.SQL.Clear; tmpadoquery2.SQL.Add('select * from sysobjects where xtype='''+'U'+''''); tmpadoquery2.Open; tmpadoquery1.close; while not tmpadoquery2.eof do begin tmpadoquery1.sql.clear; tmpadoquery1.sql.add('delete from '+tmpadoquery2.fieldbyname('name').asstring); tmpadoquery2.next; end; tmpadoquery1.execsql end;
tmpadoquery1:tadoquery;
tmpadoquery2:tadoquery;
begin
tmpadoquery1:=tadoquery.create();
tmpadoquery2:=tadoquery.create();
tmpadoquery1.connection:=odfo;//master数据库;
tmpadoquery2.connection:=djfkk;//你要删除表的数据库
tmpadoquery2.Close;
tmpadoquery2.SQL.Clear;
tmpadoquery2.SQL.Add('select * from sysobjects where xtype='''+'U'+'''');
tmpadoquery2.Open;
tmpadoquery1.close;
while not tmpadoquery2.eof do
begin
tmpadoquery1.sql.clear;
tmpadoquery1.sql.add('delete from '+tmpadoquery2.fieldbyname('name').asstring);
tmpadoquery2.next;
end;
tmpadoquery1.execsql
end;
end;