DataDirect Connect for ODBC User's Guide and Reference

rc = SQLTables (NULL, NULL, NULL, NULL, "Customers",
SQL_NTS, NULL);
SELECT ... FROM SysTables WHERE TableName = ’Customers’
UNION ALL
SELECT ... FROM SysViews WHERE ViewName = ’Customers’
UNION ALL
SELECT ... FROM SysSynonyms WHERE SynName = ’Customers’
ORDER BY ...
SELECT ... FROM SysTables WHERE TableName = 'Customers' and
Owner = 'Beth'