Check if a table exists in the database

[dataforums]

Hi,
I am trying to create dynamic tables but I want to check if they already exists in the database. Can anyone please tell me how to check if a table already exists in a sql server database??

Thanks in advance.

 

[Catadmin]

Try this:

select * from dbo.sysobjects where id = object_id(N'[dbo].[TableName]')

Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[DBAWinnipeg]

Select(object_id('tbl_TABLE'))

If this returns NULL then the table doesn't exist. If it returns a value then the table does exist.


Hope this helps


- DBAWinnipeg

 

[dataforums]

Thanks a lot!!

 

[chaoma]

You mean something like this?

if exists (select * from dbo.sysobjects where name = 'tablename')
begin
....
end

 

[Welshbird]

I'd do it like this:

If exists (select * from information_schema.tables where table_name = 'Table')
begin
...
end

Fi.

"The question should be, is it worth trying to do, not can it be done"