如果要一并全部显示就这样:
-----------------------------------
procedure TForm1.Button2Click(Sender: TObject);
var
a:string;
begin
with adoquery1 do
begin
sql.Clear;
sql.Add('select * from sysdatabases');
open;
while not eof do
begin
a :=a+Fieldbyname('name').AsString+'//';{这里把所有数据库合并成字符串了}
next;
end;
showmessage(a);
end;
end;
这里,你就可以看见所有的数据库了
记住:ADOQuery1的connectionstring要连接到master!!
------------------------------------------------------
procedure TForm1.Button1Click(Sender: TObject);
begin
with adoquery1 do
begin
sql.Clear;
sql.Add('select * from sysdatabases');
open;
while not eof do
begin
showmessage(Fieldbyname('name').AsString);
next;
end;
end;
end;
sqlserver
1. select a.name username,b.name databasename from master.dbo.sysxlogins a,master.dbo.sysdatabases b where a.dbid=b.dbid
2. select * from dbo.sysobjects where type='U'