How to test if a table is present on a database

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ric Sierra SSCrazy Points: 2260 More actions · Answer 1

Hi,

You can check using this qry:

USE yourDatabase

select * from sysobjects where name = 'yourTable'

Hello from Guatemala,

Ricardo

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 2

If you are looking for tables you have to add xtype to the previous query:

select * from sysobjects where name = 'yourTable' and xtype = 'U'

Also, you can query the view information_schema.tables:

select * from information_schema.tables where table_name = 'yourTable'

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 3

YAW alternative (Yet Another Way)

-- If assumption is to check for existance first

IF OBJECT_ID('dbo.myTable') IS NOT NULL AND OBJECTPROPERTY(OBJECT_ID('dbo.myTable'), 'IsTable') = 1

-- If assumption is to check for non-existance first

IF OBJECT_ID('dbo.myTable') IS NULL

/Kenneth

didier Geofroy Valued Member Points: 62 More actions · Answer 4

Valued Member

Points: 62

November 25, 2005 at 7:32 am

It works very fine !! Thanks a lot