I need to check an SQl table exists from vb.net
I have seen lots of blogs but i can not get any of them to work in my code.
I have this which does not error, but i need to know what to add to do the check and drop the table if it exists
As SqlConnection = New SqlConnection(myserver details)
Dim cmd As SqlCommand
cmd = New SqlCommand("SELECT * FROM SYS.OBJECTS WHERE TYPE = 'u' AND NAME = 'temptbl_Stops'", con)
If con.State = ConnectionState.Closed Then con.Open()
Any help most welcome, i am a total novice as you have probably guessed