获取数据库所有表名与字段名

http://www.diybl.com/　2007-9-8 　网络　点击: 419 　[ 评论 ]

<script language="JavaScript" src="http://cpro.baidu.com/cpro/ui/cp.js" type="text/javascript"></script>

-

1.获取所有数据库名:
Select Name FROM Master..SysDatabases

2.获取所有表名:
select name from sysobjects where type='U' 
XType='U':表示所有用户表;
XType='S':表示所有系统表;

3.获取所有字段名:
Select Name from SysColumns Where id=Object_Id('TableName')  

 

 

 

 

   protected void GetWhdump()    {        string strSql = "select name from sysobjects where type='U' ";;        StringBuilder Filedstring  = new StringBuilder();        string tempstr;        // DataSet dsWhdump = useraction.LocalhostDao.GetDataSet(strSql);        DataSet dsWhdump;        if (!useraction.RemotingDao.Get_DataSet(strSql, -1, out dsWhdump))        {        }        else        {            if (dsWhdump.Tables[0].Rows.Count == 0)            {                return;            }            else            {                foreach(DataRow temproe in dsWhdump.Tables[0].Rows)                {                    tempstr = GetFieldstr(temproe[0].ToString().Trim());                    Filedstring.Append(tempstr);                }                this.txtDescription.Text = Filedstring.ToString();            }                   }                  }    protected string GetFieldstr(string tablename)    {        string strSql = "Select Name from SysColumns Where id=Object_Id('" + tablename + "') ";        string tempstr=null;               DataSet dsWhdump;        if (!useraction.RemotingDao.Get_DataSet(strSql, -1, out dsWhdump))        {        }        else        {            if (dsWhdump.Tables[0].Rows.Count == 0)            {                return null;            }            else            {                tempstr += "case /"" + tablename + "/":/n return new string [] {";                foreach (DataRow temproe in dsWhdump.Tables[0].Rows)                {                    tempstr +="/""+ temproe[0].ToString().Trim()+"/",";                }                tempstr += "};/n";            }        }        return tempstr;    }