ASP中怎样读出数据库名，表名，和字段名？？？ SQL的也行
拜托，拜托 问题点数：80、回复次数：5Top
1 楼fbj007（千里独行）回复于 2002-09-17 16:19:37 得分 40
读出表中字段名的方法：
while not rs.eof
for i=0 to rs.fields.count-1
response.write rs.fields(i).name
next
rs.movenext
wendTop
2 楼fbj007（千里独行）回复于 2002-09-17 16:21:37 得分 0
检测出一个数据库中有哪些数据表?http://www.csdn.net/Expert/TopicView1.asp?id=1011763Top
3 楼abigfrog（千年精灵)(★JAVA★）回复于 2002-09-17 16:23:52 得分 40
读表名的方法：
< %'---------------读access库中的表名-------------------------
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("库名称")
Set rstSchema=Conn.OpenSchema(20)
Do Until rstSchema.EOF
Response.Write "Table name:"& rstSchema(2)& "< br> "& "Table type:"& rstSchema(3)& "< br> < br> "
rstSchema.MoveNext
Loop
%>
< %'---------------读sql server库中的表名-------------------------
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Server=IP地址;Provider=sqloledb;Database=库名称;UID=用户名;PWD=密码;"
Set rstSchema=Conn.OpenSchema(20)
Do Until rstSchema.EOF
Response.Write "Table name:"& rstSchema(2)& "< br> "& "Table type:"& rstSchema(3)& "< br> < br> "
rstSchema.MoveNext
Loop
%>
< %'---------------读oracle库中的表名-------------------------
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据源名称"
Set rstSchema=Conn.OpenSchema(20)
Do Until rstSchema.EOF
Response.Write "Table name:"& rstSchema(2)& "< br> "& "Table type:"& rstSchema(3)& "< br> < br> "
rstSchema.MoveNext
Loop
%>
只要用相应的数据库代替以上的中文就可以Top
4 楼bestpeaker（庄周）回复于 2002-09-17 16:47:04 得分 0
关注Top
5 楼seafarer777（手拿胡萝卜就敢装托塔李天王）回复于 2002-12-17 10:27:33 得分 0
MarkTop
