G
Guest
Hi
how can I test if a specific table on an SQL- Server (that I'm connected to) exists or not
Thank
Sam
how can I test if a specific table on an SQL- Server (that I'm connected to) exists or not
Thank
Sam
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
V
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
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