在ASP里面
sql = "select name from sysobjects where name='table1' and xtype='U'"
rs.Open sql,conn,1,3
If not rs.EOF Then
Response.write "表不存在!"
Response.End
End If
rs.Close
sql = "select name from sysobjects where name='tablename'"
rs.open sql,con,1,3
if not rs.eof then
response.write "表存在!"
else
response.write "表不存在!"
end if