SqlServer:用户表
select name from sysobjects
where xtype = 'u'
系统表
select name from sysobjects
where xtype = 's'
select name from sysobjects
where xtype = 'u'
系统表
select name from sysobjects
where xtype = 's'
调试欢乐多
对了,你需要Oracle版本的吗?
如果你想告诉我的话?我是很乐意得。
sqlserver.我如何用 query查询。不好意思,我刚上手
try
Session.GetTableNames('DBDEMOS', '*.db',False, False, MyStringList);
combobox.Items = MyStringList;
finally
MyStringList.Free;
end;
数据库名:dbserver.
ADOConnection就更简单了,ADOConnection1.GetTableNames(combobox.Items, False);