select name from sysobjects where type=‘u’and name='tablename'
不能直接用一个建表的SQL语句来判断吗??如果有应该会有提示吧
以下使用ADOX Dim cat As New ADOX.Catalog Dim tblNew As New ADOX.Table cat.ActiveConnection = OleCnn '数据库连接对象 With cat For Each tblNew In .Tables If tblNew.Name = "MyTableName" Then MsgBox "Find it" End If Next tblNew End With
Dim cat As New ADOX.Catalog
Dim tblNew As New ADOX.Table
cat.ActiveConnection = OleCnn '数据库连接对象
With cat
For Each tblNew In .Tables
If tblNew.Name = "MyTableName" Then
MsgBox "Find it"
End If
Next tblNew
End With