用asp程序显示sql数据库所有表的名称

""" & vbCrLf)
Response.Write(" cellspacing=""0"" width=""100%"">" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
'' This selects the table that we want to use.
strSQL="select * from " & Request.QueryString("table") & ""
set adoRS=adoConn.execute(strSQL)
'' Now lets start the table
Response.Write("<table border=""1""><tr>" & vbCrLf)
'' this will find all the fields in that table and write them out
FOR EACH fieldname IN adoRS.fields
Response.Write("<td><font size=""2"">" & fieldname.name & "</TD>")
NEXT '' fieldname
Response.Write("<td><font size=""2"">删除</TD>")
Response.Write(" </tr>" & vbCrLf)
DO UNTIL adoRS.eof
Response.Write("<tr>")
FOR EACH fieldname IN adoRS.fields
strFieldValue=fieldname.value
strField=fieldname.name
IF isnull(strFieldValue) THEN
strFieldValue=shownull
END IF
IF trim(strFieldValue)="" THEN
strFieldValue=showblank
END IF
IF strField = "ID" OR strField = "id" THEN
strRecordID = strFieldValue
END IF
Response.Write("<td valign=top><font size=""2"">" & strFieldValue &  

"</td>" & vbCrLf)
NEXT
Response.Write("<td valign=top><font size=""2""><a href=""index.asp?table=" &

Request.QueryString("table") & "&id=" & strRecordID & "&action=del"">删除</td>" &  

vbCrLf)
adoRS.movenext
LOOP
Response.Write("</table>")
adoRS.close
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" </table>" & vbCrLf)
Response.Write(" </center></div></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write("</table>" & vbCrLf)
Response.Write("</center></div>" & vbCrLf)
End Sub
%>