VB查找sqlserver中是否存在某张表
cn是adodb.connection对象,已经打开了数据库,现在查找数据库内是否存在名字是lblu.caption的表,如果不存在,则创建
Dim rs As New ADODB.Recordset
strsql = "select * from sys.tables where name = '" & lblu.Caption & "'"
rs.Open strsql, cn, 3, 3
If rs.RecordCount = 0 Then
strsql = "create table " & lblu.Caption & " (friend nvarchar(20) primary key)"
cn.Execute (strsql)
MsgBox "创建表成功"
End If
rs.Close