SqlConnection question

[Sam Johnson]

Hi

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

Thank
Sam

[Bill Manring]

Sam

You could run a query against the sysobjects table in the databse you are connected to

The query could look something like this

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTableName]') and OBJECTPROPERTY(id, N'IsUserTable') = 1

Hope this help

[Bill Manring]

Sam

You could run a query against the sysobjects table in the databse you are connected to

The query could look something like this

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTableName]') and OBJECTPROPERTY(id, N'IsUserTable') = 1

Hope this help

[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

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

[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

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

[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...b;en-us;309488

--
Val Mazur
Microsoft MVP
"Sam Johnson" <an*******@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...

Hi,

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

Thanks
Sam

[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...b;en-us;309488

--
Val Mazur
Microsoft MVP
"Sam Johnson" <an*******@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...

Hi,

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

Thanks
Sam