<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="inc/sql.asp"-->
<%
Set rstSchema = db.OpenSchema(20)
Do Until rstSchema.EOF '遍历数据库表
if rstSchema("TABLE_TYPE")="TABLE" then 
response.write rstSchema("TABLE_NAME") & ":" 
set rs=db.execute("select * from " & rstSchema("TABLE_NAME"))
for i=0 to rs.fields.count-1 '遍历表中字段
response.write rs(i).name &" "
next 
end if 
response.write "<br>" 
rstSchema.MoveNext
Loop 
%>