当写的一个用来查看MS sql server表结构的一个脚本(本来打算用来剽窃的)

核心提示：<%Set conn = Server.CreateObject("ADODB.Connection")conn.open "ODBC名","用户名","密码"Sql1="select * from dbo.sysobjec

　　<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "ODBC名","用户名","密码"



Sql1="select * from dbo.sysobjects where type not in('S','D','K')"
Sql1="select * from dbo.sysobjects where type ='U'"
set rscc = server.createobject("ADODB.recordset")
set rs = server.createobject("ADODB.recordset")
rscc.open sql1,conn,1,2

　do　while not rscc.eof


　 sql ="select　* from "&RSCC("name")
　 
　 rs.open sql,conn,1,2
　response.write "<hr>表名"&RSCC("name")&"<br>"
if "1"="1" then
　for i=0 to rs.Fields.Count-1

　response.write "字段名:"&rs.fields(i).name &"<br>"
　response.write "类型:"
　if rs.fields(i).type="3" then
　　response.write "int"
　　if rs.fields(i).Attributes="16" then response.write "　自动编号字段"
　　if rs.fields(i).Attributes="120" then response.write "　允许空"
　　if rs.fields(i).Attributes="24" then response.write "　不允许空"
　elseif rs.fields(i).type="129" then
　　response.write "char"
　　response.write "大小"&rs.fields(i).DefinedSize
　　if rs.fields(i).Attributes="120" then response.write "　允许空"
　　if rs.fields(i).Attributes="24" then response.write "　不允许空"
　elseif rs.fields(i).type="201" then
　　　response.write "text"
　　　if rs.fields(i).Attributes="234" then response.write "　允许空"
　　　if rs.fields(i).Attributes="138" then response.write "　不允许空"
　elseif rs.fields(i).type="202" then
　　　response.write "nvarchar"
　　　response.write "大小"&rs.fields(i).DefinedSize
　　　if rs.fields(i).Attributes="8" then response.write "　!　　 不允许空"
　　　if rs.fields(i).Attributes="104" then response.write "!　　 允许空"
　elseif rs.fields(i).type="131" then
　　　response.write "numeric"
　　　if rs.fields(i).Attributes="120" then response.write "　允许空"
　　　if rs.fields(i).Attributes="24" then response.write "　不允许空"
　elseif rs.fields(i).type="2" then
　　　response.write "smallint"
　　　if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　　if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="11" then
　　 response.write "bit"
　　 if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　 if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="135" then
　　 response.write "smalldatetime"
　　 if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　 if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="203" then
　　 response.write "ntext"
　　 if rs.fields(i).Attributes="234" then response.write "!　　 允许空"
　　 if rs.fields(i).Attributes="138" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="6" then
　　 response.write "money"
　　 if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　 if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="130" then
　　 response.write "nchar"
　　 if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　 if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="4" then
　　 response.write "real"
　　if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="5" then
　　response.write "flat"
　　if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　elseif rs.fields(i).type="128" then
　　response.write "binary"
　　if rs.fields(i).Attributes="120" then response.write "!　　 允许空"
　　if rs.fields(i).Attributes="24" then response.write "　!　　 不允许空"
　else
　　response.write "未知"&rs.fields(i).type
　end if

　response.write "　　 属性:"&rs.fields(i).Attributes
　response.write "-------------<br>"

　next
end if
rs.close

'------------------