RE: Database tbl Check

[Robertson-Ravo, Neil (RX)]

in SQL Server it can be done easily...


create procedure doesTableExist @table varchar(200)
as
if exists (
select * from information_schema.tables where table_name = @table and
table_type = 'base table')
select '1'
else
select '0'


example : exec doesTableExist 'yourtable'


it will return 1 or 0 (True or False)


N



   _____  

From: Ernie Pena [mailto:[EMAIL PROTECTED]
Sent: 19 February 2004 13:57
To: CF-Talk
Subject: Database tbl Check

Is it possible to check to see if a table exists in a database (MS Access or
SQL) and return a controled error?

Thanks in advanced
Ernie Pena
   _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---