答案同下-_-#--所有表 select name from sysobjects --如果只想得到用户表 select name from sysobjects where xtype='u'
使用Ado.net執行下面的查詢,讀取返回的數據集即可SQL Server: select name from sysobjects where xtype='u'Access: SELECT MSysObjects.Name FROM MSysObjects WHERE ((Left([Name],4)<>"MSys") AND ((MSysObjects.Type)=1))
select name from sysobjects
--如果只想得到用户表
select name from sysobjects where xtype='u'
select name from sysobjects where xtype='u'Access:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE ((Left([Name],4)<>"MSys") AND ((MSysObjects.Type)=1))
strConnection += @"Data Source=C:\Users\zhangqiang\Desktop\db1.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();OleDbCommand com = new OleDbCommand("SELECT * FROM SysObjects", objConnection);
OleDbDataReader reader = com.ExecuteReader();
我写的对吗?
http://www.cnblogs.com/jasmin/archive/2006/12/11/588644.html
下面是我得到的表
MSysObjects MSysACEs MSysQueries MSysRelationships MSysAccessObjects 选课表 注册表 MSysAccessXML
WHERE ((Left([Name],4) < >"MSys") AND ((MSysObjects.Type)=1))