sql server odbc: How can I check if table already exists in a DB?
Today I just create my table at startup, if it exist I get a error telling
me that the table already exist, ignoring the error message.
But this is a dirty way of doing it. Any other idea.
It must be quick and clean.

Hi !
[quoted text, click to view]

If you generate sql script for table and check "generate drop object" on ,
you will see in generated scipt something like this :

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

where 'accounts' is my tablename.

You can use this approach or , using odbc API , try to get table metadata,
i'm sure it should be way to get it, just never tried it.


Regards,Alexander

Or try this:

USE [YourDB]
IF EXISTS (
SELECT name
FROM sysobjects
WHERE type = 'u' AND
name = N'YourTable' -- Remove N if not using unicode
)
BEGIN
-- Do action
END


Regards,
Johan


[quoted text, click to view]
use SQLTables function

[quoted text, click to view]

Thanks to you all...

[quoted text, click to view]

use SQLTables function

[quoted text, click to view]

IF OBJECTPROPERTY ( object_id('authors'),'ISTABLE') = 1
print 'Authors is a table'

[quoted text, click to view]