Hello All,

Is there any system stored procedure which can tell if a table already
exists in the db?

I know how to do this by a query ... but that makes code unreadable.

regards,
Abhishek.

  I think that running a query against the information_schema views should
be fine,   but you can also use the OBJECT_ID ('TableName') function.  If it
returns NULL, then the object doesn't exist

Adi

IF OBJECT_ID('dbo.YourTable') IS NOT NULL
    -- Do your thing

--

Andrew J. Kelly
SQL Server MVP

Be aware that Object_ID() only returns a status whether or not an object
exists.

e.g.
create proc myTable
as
select 1
go

--false info
if object_id('myTable') is not null
print 'False: myTable exists'

--using undoc second parameter
if object_id('myTable','U') is not null
print 'myTable exists'
go

drop proc myTable
go

--
-oj
Rac v2.2 & QALite
http://www.rac4sql.net

Hi Abhishek,

You can check existance of table by querying Sysobjects system table.

if exists (select * from sysobjects where id =
object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)
  Print 'Table Exists'
GO

By using this query.

Regards
Hari Sharma, India