Re: SqlConnection question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 04/22/04

Next message: Val Mazur: "Re: Trouble with my stream"
Previous message: Val Mazur: "Re: Problem with accessing table in access database"
In reply to: Sam Johnson: "SqlConnection question"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 21 Apr 2004 23:22:09 -0400

Hi Sam,

You could query system tables. but if you want to be generic, then use
OpenSchema method if ADO or GetOledbSchemaTable method if ADO.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;309488

-- 
Val Mazur
Microsoft MVP
"Sam Johnson" <anonymous@discussions.microsoft.com> wrote in message 
news:6E8AF8A0-6818-400D-AFAB-A1387201F54B@microsoft.com...
> Hi,
>
> how can I test if a specific table on an SQL- Server (that I'm connected 
> to) exists or not?
>
> Thanks
> Sam

Next message: Val Mazur: "Re: Trouble with my stream"
Previous message: Val Mazur: "Re: Problem with accessing table in access database"
In reply to: Sam Johnson: "SqlConnection question"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: SqlConnection question
... OpenSchema method if ADO or GetOledbSchemaTable method if ADO.NET ... Val Mazur ... "Sam Johnson" wrote in message ...
(microsoft.public.dotnet.general)
Re: SqlConnection question
... OpenSchema method if ADO or GetOledbSchemaTable method if ADO.NET ... Val Mazur ... "Sam Johnson" wrote in message ...
(microsoft.public.dotnet.framework)
Re: How to retrieve schema/structure of a table ??
... You could use OpenSchema method of ADO connection to do this. ... Val Mazur ... "Atif" wrote in message ...
(microsoft.public.vb.database.ado)