<%
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 "
表名"&RSCC("name")&"
"
if "1"="1" then
for i=0 to rs.FIElds.Count-1
response.write "字段名:"&rs.fIElds(i).name &"
"
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 "! 允許空"
您正在看的SQLserver教程是:當寫的一個用來查看MS SQL Server表結構的一個腳本(本來打算用來剽竊的)。 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
您正在看的SQLserver教程是:當寫的一個用來查看MS SQL Server表結構的一個腳本(本來打算用來剽竊的)。 response.write " 屬性:"&rs.fIElds(i).Attributes
response.write "-------------
"
next
end if
rs.close
'------------------
