ADO可以
如If mcnn.State = adStateOpen Then
Set mrecd = mcnn.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE"))
If Not mrecd Is Nothing Then
Do While Not mrecd.EOF
If UCase(Left(mrecd!Table_name, 4)) <> "MSYS" Then
If UCase(Left(mrecd!Table_name, 11)) <> "SWITCHBOARD" Then
newxz = mrecd!Table_name
Form2.Combo1.AddItem newxz
End If
End If
mrecd.MoveNext
Loop
Form2.Combo1.AddItem DEF_CUSTOM_SQL
End If
给分
如If mcnn.State = adStateOpen Then
Set mrecd = mcnn.OpenSchema(adSchemaTables, Array(Empty, Empty, Empty, "TABLE"))
If Not mrecd Is Nothing Then
Do While Not mrecd.EOF
If UCase(Left(mrecd!Table_name, 4)) <> "MSYS" Then
If UCase(Left(mrecd!Table_name, 11)) <> "SWITCHBOARD" Then
newxz = mrecd!Table_name
Form2.Combo1.AddItem newxz
End If
End If
mrecd.MoveNext
Loop
Form2.Combo1.AddItem DEF_CUSTOM_SQL
End If
给分
Dim rstSchema As ADODB.Recordset
Dim strCnn As String
Set cnn1 = New ADODB.Connection
strCnn = "driver={SQL Server};server=srv;" & _
"uid=sa;pwd=;database=pubs"
cnn1.Open strCnn
Set rstSchema = cnn1.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
Debug.Print "Table name: " & _
rstSchema!TABLE_NAME & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE & vbCr
rstSchema.MoveNext Loop
rstSchema.Close
cnn1.Close