SqlConnection question

[Guest]

Hi

how can I test if a specific table on an SQL- Server (that I'm connected to) exists or not

Thank
Sam

 

[Mary Chipman]

If you're already connected to a specific database you can use the
following query to determine if the table exists.

SELECT table_name FROM INFORMATION_SCHEMA.TABLES
WHERE table_type = 'BASE TABLE'

The other choice for table_type is 'VIEW'.

--Mary

 

[Val Mazur]

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