GetTableNames(): Determining system tables from list

Article View: borland.public.cppbuilder.database.ado

Article #64

Back to borland.public.cppbuilder.database.ado Previous Next

#64

From: Mike K
Date: Mon, 03 Dec 2007 17:31

10 lines
1214 bytes

Using ADOConnection->GetTableNames() returns a StringList of all tables 
in a database.

I need to run queries only on user-defined tables from this list. How 
can I look at each table name and determine if it's a system table 
(e.g., CHECK_CONSTRAINTS)?

TIA

Mike

Technical Details

Message-ID: <47543d71$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,d571cd56a1a6356e,start
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 03 Dec 2007 11:31:29 -0600
From: Mike K <nospam@nospam.net>
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: GetTableNames(): Determining system tables from list
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 74.38.241.126
Message-ID: <47543d71$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196703089 74.38.241.126 (3 Dec 2007 09:31:29 -0700)
Lines: 10
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!tudelft.nl!txtfeed1.tudelft.nl!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail