QUESTION POSED ON: 23 May 2005 How do I display all of the tables from SQL Server using Visual Basic 6.0? For example, if I have three tables in a public database, how do I display only the table names that are in the public database?
>
EXPERT RESPONSE
I would recommend using the Information Schema Views in your database and specify the correct WHERE clause. Here is an example:
USE Pubs
SELECT Table_Name
FROM INFORMATION_SCHEMA.Tables
WHERE Table_Name IN ('Authors', 'Titles', 'TitleAuthor')
Do you have comments on this Ask the Expert Q&A? Let us know.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
