获取数据库架构信息,GetSchema(),参数表
CollectionName MetaDataCollections DataSourceInformation DataTypes Restrictions ReservedWords Users Databases Tables Columns StructuredTypeMembers Views ViewColumns ProcedureParameters Procedures ForeignKeys IndexColumns Indexes UserDefinedTypes privateDataTableGetSqlDatabaseSchema(stringstrConn,stringcollectionName,string[]strs) { SqlConnectionconnection=newSqlConnection(strConn); DataTableschema=newDataTable(); try { connection.Open(); if(!string.IsNullOrEmpty(collectionName)) { if(strs!=null&&strs.Length>0) { schema=connection.GetSchema(collectionName,strs); } else schema=connection.GetSchema(collectionName); } else schema=connection.GetSchema(); } catch { schema=null; } finally { connection.Close(); } returnschema; } 本文转自today4king博客园博客,原文链接:http://www.cnblogs.com/jinzhao/archive/2009/07/29/1534023.html,如需转载请自行联系原作者