SQLTables (Extension Level 1)

  • Article

The SQLTables function returns a list of table names that are stored in a specific data source. The information is returned in a result set. This function can also be used to enumerate either the table qualifiers in the data source or the owners in a given data source. ODBC table qualifiers correspond to WMI namespaces so use SQLTables to enumerate all the WMI namespaces.

Note  For more information about support or requirements for installation on a specific operating system, see Operating System Availability of WMI Components.

An extra column is added to the SQLTables result set. This extra column is used to return the table metadata. The format of the metadata is identical to that returned by SQLColumns.