如何遍历sql2000数据库，返回库中每个表的表名？

tanc2001 2005-02-24 10:51:30

...全文

336 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

mobydick 2005-02-24

打赏
举报

http://dotnet.aspx.cc/ShowDetail.aspx?id=BCEAADFB-CFF3-4804-B3B3-6C7D6488982B
这个最快

doubon 2005-02-24

打赏
举报

select name from sysobjects where xtype = 'U' and name <> 'dtproperties'

chinasqf 2005-02-24

打赏
举报

SELECT name FROM sysobjects WHERE (xtype = 'u')

rachy 2005-02-24

打赏
举报

SELECT name FROM sysobjects WHERE (xtype = 'u')

sqlserver本身就是一个系统，记录了所有用户更改的信息

web_gus 2005-02-24

打赏
举报

学习

jialiang 2005-02-24

打赏
举报

SELECT name FROM sysobjects WHERE (xtype = 'u')

whmjw 2005-02-24

打赏
举报

添加Sqldmo的引用,再用下面的函数加到listbox中去
服务器名数据库名用户名密码
private void GetTableList(string strServerName,string strDBName,string strUserName,string strPwd)
{
this.listBox2.Items.Clear();
string strConStr = " data source="+ strServerName +";initial catalog="+strDBName +
";password="+ strPwd+";persist security info=True;user id="+ strUserName;
SqlConnection conn = new SqlConnection(strConStr) ;
ArrayList alTbs = new ArrayList() ;

string strSql="select * from sysobjects where (xtype='u' or xtype='p') and category<>2 order by name";
SqlCommand comm=new SqlCommand(strSql,conn);
SqlDataReader dr=null;

conn.Open();
dr=comm.ExecuteReader();
//frmWizard.alist.Clear();
while(dr.Read())
{
string strName=dr["name"].ToString();
bool blTable=dr["xtype"].ToString().Trim().ToUpper()=="U"?true:false;
if(blTable==true)
{this.listBox2.Items.Add(strName);}
}
}

miaowei127 2005-02-24