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
On Sun, 18 Apr 2004 06:41:02 -0700, "Sam Johnson"
<an*******@discussions.microsoft.com> wrote:
Hi,
how can I test if a specific table on an SQL- Server (that I'm connected to) exists or not?
Thanks
Sam