<< Click to Display Table of Contents >>

pszWild

SQL: The search string has the following format: <ownername>.<objectname>. If no period is embedded in the wildcard string, it is assumed that pszWild represents a search for the object name only, and that the requested tables are for the current owner.

The following table provides examples of wildcard use for SQL databases:

Setting

Retrieves

NULL

All tables.

*.*

All tables for all owners. The default if NULL is passed.

*

All tables for the current owner.

*.EMP

All tables named EMP for all owners.

*CUST

All tables for the current owner ending in CUST.

Standard: For standard databases, search conventions are those used by DOS.