Re: Newbie question: How to check for a tables existence in a smart (fast) way ??

In article <MPG.f1f1c40fe05c4aa9898ae_at_news>, BradMurray_at_SeeSignatureIfThere.com (Brad Murray) writes:

[snip]

> Who said anything about Access? I thought this was an Oracle newsgroup.
 

> The Oracle answer can be found in my previous post.

Well, this thread is being crossposted to comp.databases, comp.databases.ms-access, and comp.databases.ms-sqlserver as well as to an Oracle newsgroup. The right answer depends on what front-end is being used. Hopefully the client tool supports a decent way to inspect the lists of tables, views, and other objects in the server database.

> _______________________________________________________________________
> Bradley S. Murray Princeton Computer Consulting (609) 730-9100
> BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651
 

-- 
Joe Foster <mailto:jfoster_at_ricochet.net> Spam is irrelevant. Assimilate this:
<ftp://ftp.microsoft.com/softlib/index.txt> Microsoft's master patch list
<ftp://ftp.microsoft.com/softlib/mslfiles/> MS I got yer patch right here!
<http://www.microsoft.com/kb/default.asp>   MS Knowledge Base
<http://www.dejanews.com/home_ps.shtml>     Usenet search and archival engine
<http://www.altavista.digital.com>          WWW *and* Usenet search engine
WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!