取得库文件内的表名

        /// <summary>
        
/// 取得库文件内的表名
        
/// </summary>
        
/// <returns></returns>

//Access:
        private ArrayList GetMdbTableName()
        {
            ArrayList al 
= new ArrayList();
            DataTable dataTableschema 
= this.mconn1.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, 
                
new object[]{nullnullnull"TABLE"});
            
foreach(DataRow dr in dataTableschema.Rows)
                al.Add(dr[
"Table_Name"].ToString());
            
return al;
        }


//oracle:
select table_name from user_tables


//sql server:
select *from sysobjects where type='U'
原文地址:https://www.cnblogs.com/wjhx/p/470774.html