Check for existance of a table

Lizu · June 13th, 2004, 02:51 PM

Hi,

I have a sql server with thousands of tables which I would like to link back to an access frontend only when they are required.

Please would someone kindly advise the correct sql to send to the server to check if a user table exists, before the application programme attempts to create a link for the table.

many thanks

Lizu

bmains · June 13th, 2004, 05:48 PM

select * from INFORMATION_SCHEMA.Tables where TABLE_NAME = '<table name>'

happygv · June 14th, 2004, 03:19 PM

You can also use this.

Code:

SELECTE * FROM sysobjects WHERE NAME = <TABLE_NAME> and TYPE='U'

Cheers!

_________________________
-Vijay G

Strive for Perfection

Jeff Mason · June 14th, 2004, 04:06 PM

This of course begs the question of what on earth would a database be doing having "...thousands of tables..." in it, and what a user application would be doing not knowing what those tables are.

I'm guessing we have a design here where each table is really a single entity, instead of that entity being a row in just one table...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com