select name from sysobjects where xtype = 'U' and name like '%sf0207%' select name from sysobjects where xtype = 'U' and name like '%sf02%' 参考一下,呵呵
var sTableList: TStrings; begin sTableList:=TStringList.Create(); try adoConnection.Connected:=true; adoConnection.GetTableNames(sTableList,false); ShowMessage(sTableList.Text);//显示所有表名 finally sTableList.Free; end end; 在表名中找吧
select name from sysobjects where xtype = 'U' and name like '%sf02%'
参考一下,呵呵
sTableList: TStrings;
begin
sTableList:=TStringList.Create();
try
adoConnection.Connected:=true;
adoConnection.GetTableNames(sTableList,false);
ShowMessage(sTableList.Text);//显示所有表名
finally
sTableList.Free;
end
end;
在表名中找吧